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

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.
--
David Biddulph

"Vlado Sveda" wrote in message
...
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
---------------
Jacob Skaria


"Vlado Sveda" wrote:

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

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

Once more thank a lot !

Vlado

On Nov 26, 6:14*pm, Vlado Sveda
wrote:
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