Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to update all worksheets before re-calculation? | Excel Discussion (Misc queries) | |||
Data Validation lists update orginal cell with list update | Excel Worksheet Functions | |||
auto-hide rows, cell format (# and @), update cell refs, shade cel | Excel Discussion (Misc queries) | |||
Populating Last Saved Date in Cell AND also update that same cell in Header | Excel Discussion (Misc queries) | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions |