Cumulative Total with a twist
 

I am useing Office XP
I use this formula =IF(CELL("address")="$A$4",A4+B4,B4)
Is there a way to get it to subtract in this way
Recived total used total on hand
100 100 50 50
I know that there is no record of recived that works for me.
Can I get it to work in the same way subtracting used giving a total on
hand until I reach a total of 0 on hand. This is for my own work shop
inventory.


--
zipper21
------------------------------------------------------------------------
zipper21's Profile: http://www.excelforum.com/member.php...o&userid=33025
View this thread: http://www.excelforum.com/showthread...hreadid=529120