keep cell blank when false in IF statement

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 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)
 
To have a "blank" result for the FALSE return try this:

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

Use 2 double quotes for the FALSE option
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If statement combining average 3
Three possible outputs from an if statement. 3
If statement for a range of cells 3
Keep cell blank if condition is false in IF function 2
IF OR Statements 4
=IF(ISERROR(VLOOKUP(A3,contacts!B:I,5,FALSE)), " ", VLOOKUP(A3,con 4
Using multiple IF statements 8
If blank statement 4

Back
Top