Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Calculation using either a + or - amount
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) |
#2
|
|||
|
|||
Calculation using either a + or - amount
You can use a simple formula. E.g.,
=Starting+Received-Dispatched+Manual_Adjustment Substitute the appropriate cell references for the names in the formula. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Janet T" wrote in message ... 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) |
#3
|
|||
|
|||
Calculation using either a + or - amount
Chip
thanks a lot - I didn't realise it would be simple maths (its a long time since I left school!) :-) Janet "Chip Pearson" wrote: You can use a simple formula. E.g., =Starting+Received-Dispatched+Manual_Adjustment Substitute the appropriate cell references for the names in the formula. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Janet T" wrote in message ... 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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |