MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Leaving Blank Cell from IF function

Posted by Erin Coats on August 06, 2001 1:04 PM

I'm using Excel 2000.
When I use "" as the result of an IF statement condition, the actual result is not a BLANK cell, but is interpreted as a zero. How can I have an IF statement result in a truely blank cell? Is there some kind of CLEAR function?

Posted by Aladin Akyurek on August 06, 2001 1:20 PM


Create a fresh worksheet.

In A1 enter: =""
Leave A2 "as is".

In B2 enter: =SUM(A1) and copy down this to A2.

What do you get: 0's.

What is important is to tell us why these 0's are a problem for you. What formulas are you using that should "ignore" these funny 0's?