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?
Thanks!
Posted by Aladin Akyurek on August 06, 2001 1:20 PM
Erin
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?
Aladin
