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!
