J
Jim
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.
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.