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.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks