How to update a cell after a calculation?
 

I am creating a spreadsheet that keeps track of my inventories. I want to
set it up to do a calculation using a cell, and then update that cell with
the new number. Is this possible?

I currently want to take AB3 and Substract C2 from it and put the answer
back into AB3. Can I do this without VB or programming?

Thanks for the assist.

How to update a cell after a calculation?
 

Tony,

This in AB3

=6-C2

Displays 6 until you enter an number in c2 which is then deducted from 6

equally you can have

='your formula'-c2 in AB3

Mike

"Tony" wrote:

I am creating a spreadsheet that keeps track of my inventories. I want to
set it up to do a calculation using a cell, and then update that cell with
the new number. Is this possible?

I currently want to take AB3 and Substract C2 from it and put the answer
back into AB3. Can I do this without VB or programming?

Thanks for the assist.