Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas
I have a worksheet which calculates the usage of a consumable. Column A is
the decreasing value of a substance and the value in column B is the difference of the values in column A. So if A1 is 200 and A2 is 150 then B2 would be 50. That is the easy part. The problem is when the consumable in column A gets to a low enough value where a new container needs to be put into use. In that case the value in, let's say, A2 would be greater than the value in A1. So there needs to be an 'IF' condition to add those two values. But then there is still a third value that needs to be subtracted from the value of the first condition. The third value would be the ending amount of the consumable at the end of the day. So...if A1 is 10lbs and a new barrel is added with a value of 400lbs in A2 and the ending value of the day is 375lbs then B2 needs to be 35lbs. There needs to be a formula to be essentially: 10+400-375=35 or A1+A2-"375"=B2. The 375 value needs to be entered but there is already a value in A2 of 400. Not sure if this can be done or if there needs to be another column created. I hope this all makes sense and thank you for your help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas
Would suggest to use another column to so as to represent new barrel
additions.. If this post helps click Yes --------------- Jacob Skaria "Jim" wrote: I have a worksheet which calculates the usage of a consumable. Column A is the decreasing value of a substance and the value in column B is the difference of the values in column A. So if A1 is 200 and A2 is 150 then B2 would be 50. That is the easy part. The problem is when the consumable in column A gets to a low enough value where a new container needs to be put into use. In that case the value in, let's say, A2 would be greater than the value in A1. So there needs to be an 'IF' condition to add those two values. But then there is still a third value that needs to be subtracted from the value of the first condition. The third value would be the ending amount of the consumable at the end of the day. So...if A1 is 10lbs and a new barrel is added with a value of 400lbs in A2 and the ending value of the day is 375lbs then B2 needs to be 35lbs. There needs to be a formula to be essentially: 10+400-375=35 or A1+A2-"375"=B2. The 375 value needs to be entered but there is already a value in A2 of 400. Not sure if this can be done or if there needs to be another column created. I hope this all makes sense and thank you for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting # of Formulas in a column with formulas and entered data | Excel Worksheet Functions | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
formulas for changing formulas? | Excel Discussion (Misc queries) |