| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Negative Entry to calculate remaining inventory
Here is what I am looking to do, I am tracking inventory via a spreadsheet, I
would like to be able to put an entry on the totals cell and it will then calculate the remaining amount. So my total inventory is 1000 and I sell 250, I can input the 250 on the Total Cell (currently 1000) and it will subtract the total remaining giving me 750 in the totals cell. Is this possible? Any other suggestions on what I might do here? Thanks a lot in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| stop entry of data that causes a negative value from a formula | Excel Discussion (Misc queries) | |||
| Impact of negative sales on inventory weeks on hand | Excel Discussion (Misc queries) | |||
| Set negative numbers to zero. Do not calculate with negative valu | Excel Discussion (Misc queries) | |||
| how do i set up a worksheet to calculate the inventory? | Excel Worksheet Functions | |||
| Calculate Remaining Balance | Excel Worksheet Functions | |||
Threaded Mode
