MrExcel Publishing
Your One Stop for Excel Tips & Solutions

IM Stuck!!


Posted by Tara on January 09, 2002 3:49 PM

I am working with a worksheet where I want the result in one cell to be a cumulative result of a formula and another cell on the sheet to be the last result before the newest addition. Does this make sense?

e.g. the cells are as follows

total value - % complete – Value(total*%) – Previous Draw – Current draw

if total is $100- % complete is 25- Value would be $25-Previous Draw blank – Current draw is $25

then when a second draw is taken on progress

total = $100 - % complete is changed to 50 – Previous draw should be $25 – current draw should be $25

How do I get my sheet to calculate this for me?

Any help is appreciated,,, Im really stuck


Posted by Qroozn on January 09, 2002 4:29 PM

so your problem is showing the previous result? do the results always change in the same amount or percetange?eg +2-% each time or +.2?

Posted by Tara on January 09, 2002 4:49 PM

No, the percentages change.

Posted by Qroozn on January 09, 2002 7:43 PM

does the percentage always change by the same amount eg. 5%
eg total=100 ->present =50% -> past = 45%
eg total=100 ->present =55% -> past = 50%
eg total=100 ->present =60% -> past = 55%
eg total=100 ->present =65% -> past = 60%

Posted by Tara on January 10, 2002 5:11 AM

no, the amount it changes by is always different and depends on the progress of the project


Posted by Qroozn on January 10, 2002 5:48 PM

ok. try this.
add another cell which shows the % increase.
then you have a cell with % completed, one with the amount of the increase. and then the third cell would be "previous completion amount". where = %completed - % increase. this will give your last previous %...
does it make sense?

Posted by Tara on January 10, 2002 6:49 PM

That works.. only problem now is that changing the format of the sheet itself (adding a new column) is not possible as it is a standard form and cannot be changed. The new percentage amount will replace the old one. I would need the original % complete to be referenced outside of the printable area when replaced with the new %.

Posted by Tara on January 10, 2002 6:49 PM

That works.. only problem now is that changing the format of the sheet itself (adding a new column) is not possible as it is a standard form and cannot be changed. The new percentage amount will replace the old one. I would need the original % complete to be referenced outside of the printable area when replaced with the new %.