How To Remove #N/A in Google Sheets & Excel
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
Here is a quick example of a sample formula of an Index/Match without IFNA and with IFNA
- Without IFNA:
- With IFNA: