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 %.
