Forum Discussion
Josephlesane
Jun 18, 2019Copper Contributor
Running tally
I am trying to keep track of a 200 gallon Nitrogen tank. I need to be able to input a daily value and have excel tell me how much was used in a 24hr. period. I need it to show positive and negative as...
Twifoo
Jun 19, 2019Silver Contributor
Please attach a sample Excel file with your sample date and your manually entered results.
- JosephlesaneJun 19, 2019Copper ContributorI need this to auto calculate for the entire page as a new entry will be added daily. Thanks
- TwifooJun 19, 2019Silver Contributor
In the attached file, the formula in C2, copied down rows, is:
=IF(AND(ISNUMBER($B1),$B2>$B1),
$B2-$B1,
0)Conversely, the formula in D2, copied down rows, is:
=IF(AND(ISNUMBER($B1),$B2<$B1),
$B1-$B2,
0)