How to update a cell after a calculation?

T

Tony

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

Mike H

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF NESTED Question 4
How to make a SumIf range not a range ... but a sum of specific cells 3
When I click on my cell, it directs to me an email form..........w 4
How do you update a cell after an operation on it. 2
How do I retreive the last # in a column? 2
cell reference of a formula 2
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Cell =Now() << Can I get this to auto-update? 2

Top