Forum Discussion
spalmer
May 11, 2021Iron Contributor
Excel Formula Help
Hi Everyone, I need help trying to figure out a formula on my excel spreadsheet (attached below). im trying to track a bi weekly value of fuel moistures. once you open it, you will see on the Feb. ...
- May 11, 2021Change the formula in S34 so it reads =IF(X24=0,"",X24-'Feb. 1'!X24), and make comparable changes in the adjacent cells, and you should be fine.
mathetes
May 11, 2021Gold Contributor
Change the formula in S34 so it reads =IF(X24=0,"",X24-'Feb. 1'!X24), and make comparable changes in the adjacent cells, and you should be fine.
- spalmerMay 11, 2021Iron ContributorThat Worked! thank you so much Sir. so just so i can learn, was my issue cause i was using the ISBLANK function? and because there was a formula in those cells it wasnt reading a true blank cell?