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

December 2016




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 :

This document entitled « Excel - How to remove the #N/A entries ? » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.