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.

keep cell blank when false in IF statement
 

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

keep cell blank when false in IF statement
 

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

=IF(A10,A1,"")

Use 2 double quotes for the FALSE option.


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=487308