BLANK cell as a result of IF condition

[Vlado Sveda]

I'm trying to find a way how to use IF condition:
=IF(MyCondition; ValueIfTrue; ... else leave cell empty ...).

=IF(MyCondition; ValueIfTrue; "") is not good for me, because it does not
leave the cell empty.

Thanks in advance for every suggestions.

Vlado

 

[David Biddulph]

You can't. A formula must return a result, even if only an empty string as
you have, so if you have a formula in a cell, the cell will not be empty.

 

[Jacob Skaria]

As David mentioned you cannot leave the cell empty which means if you use
ISBlank() to check for blank that will not return TRUE . Instead you can try

=IF(A1="","do something","")

If this post helps click Yes

 

[Vlado Sveda]

David, Jacob,

thanks for your answers. I had a sinking feeling about impossibility ...,
nevertheless I tried ...

Once more thank a lot !

Vlado