BLANK cell as a result of IF condition

  • Thread starter Thread starter Vlado Sveda
  • Start date Start date
V

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
 
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
 
David, Jacob,

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

Once more thank a lot !

Vlado
 
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
 
Back
Top