Keep cell blank if condition is false in IF function

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

Guest

How do I keep the cell blank if the condition is false. Even if I don't put
anything in the false condition it keeps putting False in the cell, I want to
leave it blank.
 
Note that this makes the cell look blank, but Excel still treats it as if it
contains text. This has implications if the cell is used for subsequent
calculations or as a chart's source data.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
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

Conditional Formatting with Calculated Blank 2
Help needed 0
keep cell blank when false in IF statement 2
=IF(ISERROR(VLOOKUP(A3,contacts!B:I,5,FALSE)), " ", VLOOKUP(A3,con 4
Question about conditional formatting of zeros in Excel 0
Three possible outputs from an if statement. 3
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
Error in the IF condition 2

Back
Top