keep cell blank when false in IF statement

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.

ruthslaughter wrote:
>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.

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

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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200511/1

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

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

Use 2 double quotes for the FALSE option.