ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Update formula automatically for inventory (https://www.excelbanter.com/excel-worksheet-functions/195362-update-formula-automatically-inventory.html)

pcrumpacker

Update formula automatically for inventory
 
My cell formula is subtracting inventory. When receiving inventory how am I
able to recalculate the formula to adding by just clicking on the cell to
update. When I go to Tool, Options, Calculation and check that box, it only
subtract the number from the cell, not adding the number into the cell.

FSt1

Update formula automatically for inventory
 
hi,
it might help if you posted your fomula

regards
FSt1

"pcrumpacker" wrote:

My cell formula is subtracting inventory. When receiving inventory how am I
able to recalculate the formula to adding by just clicking on the cell to
update. When I go to Tool, Options, Calculation and check that box, it only
subtract the number from the cell, not adding the number into the cell.



All times are GMT +1. The time now is 04:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com