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.
ya of course sorry about that. so lets say i inputted data in the "Feb. 1" Tab and wasnt able to collect data for the "Feb. 15" Tab but was able to collect data for the "Mar. 1" Tab. What would the formula look like if i wanted the cells S34, V34 & Y34 in "Mar. 1" Tab to revert to the "Feb. 1" Tab data incase i miss the data in the "Feb. 15" Tab.
Hopefully i explained that better if not please let me know
Hopefully i explained that better if not please let me know
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.