Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 8th 05, 04:33 PM
rfhorn
 
Posts: n/a
Default Help with formula

I am working on a cash flow project for building a plant. I know the cost of
the various segments of the plant rounded to the nearest M. I need to show a
cash flow projection for each segment of the plant construction by month. I
am using a percent by month for the allocation for each different segment.
The monthly allocation is rounded to the nearest M also. The problem I am
having is that the monthly allocation for each segment does not always add up
to the total because of the rounding. How can I put in the last month
allocation formula a process that would, account for the difference between
the monthly allocation and the total being allocated, and then either add or
subtract that differnce to the last months allocated amount.

  #2   Report Post  
Old April 8th 05, 04:50 PM
Michael Malinsky
 
Posts: n/a
Default

If you have a simple spreadsheet with each month in a column then you could
accomplish this by manually entering the total for the year, calculating the
allocation for the first 11 months, then the final month would be the total
less the sum of the prior 11 months:

As a simple example, the months are in A1 through A12 and the total is in
A13. In A12 you would put:

=A13-SUM(A1:A11)

"rfhorn" wrote in message
...
I am working on a cash flow project for building a plant. I know the cost

of
the various segments of the plant rounded to the nearest M. I need to show

a
cash flow projection for each segment of the plant construction by month.

I
am using a percent by month for the allocation for each different segment.
The monthly allocation is rounded to the nearest M also. The problem I am
having is that the monthly allocation for each segment does not always add

up
to the total because of the rounding. How can I put in the last month
allocation formula a process that would, account for the difference

between
the monthly allocation and the total being allocated, and then either add

or
subtract that differnce to the last months allocated amount.





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
IF & VLOOKUP FORMULA taxmom Excel Worksheet Functions 3 March 2nd 05 04:35 PM
Match / Vlookup within an Array formula Hari Prasadh Excel Discussion (Misc queries) 3 February 3rd 05 05:37 PM
revert formula insertion to old method Don't be a pain in the ass Setting up and Configuration of Excel 0 January 24th 05 02:49 PM
Relative Indirect Formula Referencing? Damian Excel Worksheet Functions 1 January 7th 05 05:16 AM
Help with macro formula and variable Huge project Excel Worksheet Functions 0 December 28th 04 02:27 AM


All times are GMT +1. The time now is 11:22 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017