ISBLANK & IF or Dependent Formula

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!




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.