Forum Discussion
ISBLANK not returning correct result
this is the formula in D6:
=IF(ISBLANK('Row from SPOTR'!R3),"",'Row from SPOTR'!R3)
this is the formula in D7
=IF(ISBLANK(D6),"",IF(D6>=0.26,200,IF(D6>=24%,100,IF(D6>=21%,25,IF(D6>=0%,0)))))
SPOTR R3 is blank - I have deleted the data in it. D6 correctly shows blank, LEN(D6)=0
There are now errors showing. My issue is that as long as there's a number SPOTR R3, the formula works correctly. When I delete the data in R3, D7 shows 200 as the result when what I'm expecting/wanting is a blank cell.
A cell that contains a formula is not treated as blank by Excel, even if that formula returns the empty string "". To get around this, use
=IF(D6="", "", IF(D6>0.26, ...
HansVogelaar Thank you so much!!!! Of course it worked!! I stared at this issue for hours - so grateful for your fast reply and explanation.
