keep cell blank when false in IF statement

R

ruthslaughter

How do I keep the cell blank when doing an IF statement. I want the cell to
remain blank if the statement is false but it keeps putting False in the cell.
 
C

Chris W via OfficeKB.com

ruthslaughter said:
How do I keep the cell blank when doing an IF statement. I want the cell to
remain blank if the statement is false but it keeps putting False in the cell.
Click to expand...

If A1 is blank leave B3 blank, otherwise put A1 in B3

=IF(A1=""," ",A1)
 
C

Cutter

To have a "blank" result for the FALSE return try this:

=IF(A1>0,A1,"")

Use 2 double quotes for the FALSE option
 
Top