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