Thread: keep cell blank when false in IF statement
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Chris W via OfficeKB.com
 
Posts: n/a
Default 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
Reply With QuoteReply With Quote