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

 

[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

 

[minyeh]

David, Jacob,

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

Once more thank a lot !

Vlado

a way to achieve what u want is to
record a macro for ur calculation
=IF(MyCondition; ValueIfTrue; 1/0)
*note: 1/0 returns to an error #DIV/0!
then
F5 goto Special Formula Errors
then
DELETE
end macro recording

might not be the best solution, but hope it helps