Forum Discussion
Solved
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. ...
- 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.
In S34:
=IF(X24="","",X24-IF(COUNTA('Feb. 15'!N14:P19)=0,'Feb. 1'!X24,'Feb. 15'!X24))
Similar in V34 with X26, and in Y34 with X28.
Hans your are Awesome my friend!! thank you so much for your time and knowledge! i really appreciate it.