‍

Here's a quick and simple guide on how to remove #N/A errors in Google Sheets and Excel.

‍

• Open your formula

‍

• Add the IFNA function to the beginning of the formula

‍

• Add relevant parenthesis

‍

• Done!

‍

   Save hours formatting your next financial spreadsheet!

   100+ templates, all free to use.

   Free Spreadsheet Templates

‍

Here is a quick example of a sample formula of an Index/Match without IFNA and with IFNA

‍

• Without IFNA:

=INDEX(A1:A3,MATCH(B1,C1:C3,0))

‍

• With IFNA:

=IFNA(INDEX(A1:A3,MATCH(B1,C1:C3,0)))

‍

‍

   Turn Quickbooks Online data into a Google Sheets dashboard

    100+ templates, update automatically, totally secure!

   Book a Demo

‍