Forum Discussion
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. 1 tab i have entered my data under "Gross Weight" (highlighted in gray) towards the top. as i enter my data it gives me my % in red towards the bottom (60%, 58% and 62%). This tab is working Fine. Now click on the "Feb. 15" Tab. as you scroll towards the bottom right of the page you will see ▼ 60%, ▼58%, & ▼ 62% (IN RED). so in those cells S34, V34 & Y34 i have formulas that aren't working as i would like. i dont want anything showing up in Cells S34, V34 & Y34 until data is inputted in the "Gross Weight" (highlighted in gray) under "Wet" and "Dry" cells towards the top of the page. i think the issue is that in cells X24, X26 & X28 i also have formulas which isnt showing those cells as blank. but any help would be appreciated. Thank You.
- 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.
11 Replies
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 "".
- 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.
- That 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?
