MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Mr. Excel: How to hide cells with #N/A value - there must be a way!

Posted by Thomas on October 16, 2000 4:22 PM

I have looked all thru the excel help and tried some wacky stuff myself, to no avail. I do not have the knowledge to write scripts but have recorded a few macros. The closest I've come to solving this problem was with conditional formatting (I don't care how they're hidden, so long as I don't have to look at them so my format was white text/white background), but entering na(), #n/a, or isna(cell in question) in the criteria doesn't do squat even when it accepts the formula syntax. WTFO?

Mr Frustrated

Posted by Neil on October 16, 2000 6:29 PM

Try =IF(ISNA(A1),"",A1)

A1 Can be anything (formula, cell, vlookup etc)
"" Can be also be anything depending on how you want to hide it - "" gives a blank cell

Posted by Thomas on October 17, 2000 2:54 PM

Thank you very much - that worked like a charm

Posted by Eric on November 09, 2000 9:06 PM

Re: Mr. Excel: Need help producing an invoice sheet!! VERY URGENT...

I know how to do the invoice but I'm having trouble with the discount column (f). Using =IF(AND(CONDITION1,CONDITION2)="YES"),0.1*CELL#,0)
I keep getting a 0 value in the f column, according to my professor I should be getting a number other than zero? Why is this happening?