Keep cell blank if condition is false in IF function

How do I keep the cell blank if the condition is false. Even if I don't put
anything in the false condition it keeps putting False in the cell, I want to
leave it blank.

=if(condition,value_if_true,"")

"ruthslaughter" wrote:

> How do I keep the cell blank if the condition is false. Even if I don't put
> anything in the false condition it keeps putting False in the cell, I want to
> leave it blank.

Note that this makes the cell look blank, but Excel still treats it as if it
contains text. This has implications if the cell is used for subsequent
calculations or as a chart's source data.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

"bpeltzer" <[email protected]> wrote in message
news:[email protected]...
> =if(condition,value_if_true,"")
>
> "ruthslaughter" wrote:
>
>> How do I keep the cell blank if the condition is false. Even if I don't
>> put
>> anything in the false condition it keeps putting False in the cell, I
>> want to
>> leave it blank.