BLANK cell as a result of IF condition
 

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

BLANK cell as a result of IF condition
 

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

BLANK cell as a result of IF condition
 

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

BLANK cell as a result of IF condition
 

David, Jacob,

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

Once more thank a lot !

Vlado

BLANK cell as a result of IF condition
 

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