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.
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?
Can you explain in more detail what you want?
- 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
- Thank you so much Hans. Makes Sense now. really appreciate it!