MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Blank result of IF statement


Posted by Vikki on July 17, 2001 12:06 PM

In Excel 97, I'm trying to find a way to return a blank if my condition in an IF statement is not met, such that when I graph the range, the blanks do not graph. I've tried a number of things including "" and ,) but those graph as 0.

I'd appreciate your help!


Posted by Barrie Davidson on July 17, 2001 12:14 PM

Instead of "", try na(). This returns #N/A, which Excel doesn't graph.

Barrie

Posted by Vikki on July 17, 2001 2:26 PM

Works great! Thanks a bundle!