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))))) ...
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.