May 11 2021 11:14 AM
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.
May 11 2021 11:29 AM
SolutionMay 11 2021 11:38 AM
May 11 2021 11:41 AM
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.
May 11 2021 11:53 AM
May 11 2021 12:22 PM
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 "".
May 11 2021 01:31 PM
May 11 2021 01:45 PM
May 11 2021 02:17 PM
May 11 2021 02:31 PM
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.
May 11 2021 02:34 PM
May 11 2021 11:29 AM
Solution