Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Folks, I've been asked to develop a simple spreadsheet which measures the
amount of product stored in a Tank. The calculation starts with an opening stock, some product might be removed and other product might be received. A simple calculation ensues, which gives rise to a closing stock. However, I've now been asked to incorporate a manual adjustment field, which could be either a plus or a minus figure. I wonder if someone out there can help me with this. I'm not sure how to write the formula for this extra step in the calculation. Here's an example: Starting stock 1000 Received 200 (+) Despatched 300 (-) Closing Stock 900 Manual adjustment +5 making closing stock 905 or Manual adjustment - 5 making closing stock 895 Thanks (Hope this is understandable) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Commission Calculation with IF Stmt. | Excel Worksheet Functions | |||
formula to calculate a benefit amount | Excel Discussion (Misc queries) | |||
Calculation Setting in Excel | Excel Discussion (Misc queries) | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions |