Excel - How to remove the #N/A entries ?

July 2017




Issue


I work with Excel and I would like an effective way to remove the #N/A entries.

Solution


In formulas, you test the occurrence of #N/A using the function IsNA().
=IF(IsNA(myformula);"";myformula)

Related


Published by aakai1056. Latest update on July 30, 2012 at 04:58 AM by aakai1056.
This document, titled "Excel - How to remove the #N/A entries ?," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).