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.
See the attached version.
I changed the formulas on the Feb 1 and Feb 15 sheets; I left the Mar 1 sheet as it was.
- Thank you Hans! that works as well. So im guessing but using the ISBLANK function was my issue. Can you explain that to me please? just trying to learn and understand why it didnt work
ISBLANK only returns TRUE if the cell is really empty, i.e. it contains neither a constant value nor a formula. If the cell contains a formula, ISBLANK will return FALSE even if the formula returns an empty string "", making the cell look blank.
The comparison cell="" will return TRUE both if the cell is really empty and if the cell contains a formula that returns "".
- another question. If i wanted that formula to revert to a previous date/tab how would i do that. so just to explain it better. lets say missed to input data on the feb 15 tab, what would the formula look like for the next tab "Mar. 1" in those same cells?
