Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 1
Default Multiple If statements, Calculating quarterly % holding costs

Hi Guys/Girls

I am trying to assign %'s for a Property Holding Cost. I cannot formulate the correct IF statements to correctly calculate the below-mentioned equation (See attached document).

1 2 3 4 5 6 7 8 9 10 Time Period (Months)
10% 20% 30% 40% 50% 60% 70% 80% 90% 100% Cumulative Cost % assignment
10% 10% 10% 10% 10% 10% 10% 10% 10% 10% Spread Cost % assignment

The cost needs to be paid quarterly, i.e. month cost % 1,2&3 are totaled in Month 3(i.e. 30%). When the property is sold, the remaining 10th month holding cost is totaled to finalize the Sale (i.e. 10%).

Example: Holding Cost is $12,000, paid quarterly, the Property is sold at the end of the 10th Month.

i.e. Time Period 1-0%($0), 2-0%($0), 3-30%($3,600), 4-0%($0), 5-0%($0), 6-30%($3,600), 7-0%($0), 8-0%($0), 9-30%($3,600), 10 -Property is sold Remaining 10%($1,200).

See attached Excel: Row 17 is highlighted in yellow, the correct equation must be able to be filled across.

I seem to be able to get it, then I change the month and it exposes the formula. If you could change the holding Month Period to make sure it works, I would be most appreciative.

Thanks to anyone that can help me here

Kind Regards,

Mitchell
Attached Files
File Type: zip Quarterly Payments-Excel Forum.zip (12.1 KB, 95 views)
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculating Costs for Each period Svyatoslav Kuznyetsov Excel Programming 0 December 20th 10 05:35 PM
Calculating costs AJ Excel Worksheet Functions 2 February 4th 09 10:14 PM
Quarterly Statements in Pivot Tables TB in DC Excel Discussion (Misc queries) 2 January 10th 09 12:26 AM
Calculating shipping costs LPJR New Users to Excel 3 November 30th 05 06:16 AM
Simple Calculating Costs Tanker350 Excel Discussion (Misc queries) 1 October 19th 05 03:26 AM


All times are GMT +1. The time now is 11:12 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"