Hello All,
I am looking for a combination of IF and ISBLANK.
Ideally, if a reference cell elsewhere is blank, then the formula cell should be blank, however, if it is not, then I want a simple subtraction.
This is what I have tried, but with Err:508:
=IF(ISBLANK(C2," "),C2-36)
Any help would be greatly appreciated!
Thanks,
Baldy.
Hallo
=IF(ISBLANK(C2),"",C2-36)
btw. its bad by design to fill cells with nothing but space!
The formula doesn’t conditionally place space(s) in a cell but the empty text which is the formula result next to making the cell blank what not is feasble by a formula. I often used succesfully this kind of “conditionally making de-facto-blank” to have a way to treat cells containing an IF formula along with native blank cells by one of the conditions CellRef="" or CellRef<>""
The original Formula was intented to insert " " space, in case ISBLANK(C2)
I now see. Thanks.
Wonderful - Thank you for your help. That was exactly what I was looking for.