Question: How do I leave a cell blank if formula value is #N/A

**Chobi** · 02-20-2008, 02:58 PM

This is what I have.

I have created a drop down list of items I need to add. If the cell where my drop down is, is blank all the other cells that "auto-fill" show #N/A.

How do I get those cells to just remain blank?

I have tried the Conditional Formatting, like one would use if it was a "0" value, but that doesn't work....any suggestions?

Thanks

**NBVC** · 02-20-2008, 03:04 PM

You can revise your formula to include the ISNA condition and return a blank

e.g. =IF(ISNA(your_formula),"",your_formula)

or you can use conditional formatting to change the font colour to match the background colour...

select cell and invoke Conditional Formatting...

Select formula Is from 1st drop down and enter formula: =ISNA(A1) where A1 is cell with N/A result. Click format and choose font colour. Click ok twice to exit.