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.