IFNA Function in Zoho Sheet: Formula, Examples & Troubleshooting
Learn the IFNA formula in Zoho Sheet: catch unavailable lookup results without hiding other errors, with reproducible examples, expected answers and compatibility cautions.
Verification status: Official documentation referenced; example outcomes independently reasoned or arithmetically checked where stated. Not executed in Zoho Sheet. How formula examples are checked
Quick answer: Use IFNA to catch unavailable lookup results without hiding other errors. The example below supplies exact inputs and independently calculated expected results, so you can check your formula before replacing the demonstration values with real workbook data.
Verification: The function is covered by a vendor reference or its published formula catalogue. The worked outputs here are independently reasoned, not screenshots or native test results from Zoho Sheet. Check release-specific support and argument details in the referenced vendor help.
Syntax and arguments
=IFNA(value; value_if_na)
Only #N/A errors trigger the replacement value; other errors remain visible. In formula syntax, square brackets mark optional arguments; do not type square brackets into an ordinary formula unless the particular function requires array notation. The semicolon separator shown follows the examples in Zoho Sheet’s help; the separator shown is for the example locale and might change with spreadsheet settings.
When to use it: Use IFERROR only when all formula error types should share a recovery path.
Prepare the example inputs
In Zoho Sheet, fill A1:F9 with the sample table and enter the formula in a blank output cell. The site’s Zoho examples use semicolons for separate arguments as shown in current Zoho help articles. These two examples use literal values, so you can enter them into blank cells without first constructing a table. Their answers are independent calculations; dates must be displayed with an actual date format.
Worked example: exact formula and expected output
=IFNA(NA();"Not found")
Expected result: Not found. NA() produces an #N/A value, which is replaced with the supplied label.
- Select an unused output cell (for example H2 if the practice table occupies A1:F9).
- Enter the formula exactly as shown, including the opening equals sign and quoted text.
- Compare the displayed answer to the expected result, then inspect the source cells if it differs.
For a range formula, the row numbers include data rows only unless the example explicitly refers to headers. A result that looks plausible may still be wrong if it references the wrong column.
Second example: a different input
=IFNA(12/3;"Not found")
Expected result: 4. The number 4 is returned unchanged because there is no #N/A.
Check the alternate result in a different cell. If the input data is pasted from Excel, make sure separators and number types survived the import.
Important edge cases and a common mistake
Watch out: IFNA is narrower than IFERROR: #DIV/0! and #REF! should not be silently swallowed.
Zoho Sheet help can use specialized matching behavior and error names that differ from desktop spreadsheet programs. The results here are expected calculations, not executions inside a Zoho account.
Troubleshooting in Zoho Sheet
Check formula separators, cell types and match-type modes in Zoho Sheet’s Help. NA() is documented as a generator of #N/A; formula result errors need their own handling. Browser calculation and desktop beta behavior were not natively tested.
If you get the wrong answer but no error, try these checks in order: (1) evaluate the simplified first example; (2) confirm the cell values and data types; (3) check the exact row and column boundaries; (4) verify quoted text, comparison operators and separators; (5) only then add more criteria or nested functions.
For a reproducible comparison with another spreadsheet product, use the same input values in both applications and record the installed version and locale. Different default matching behavior or handling of empty values can be a migration issue rather than a mathematical disagreement.
Moving this formula between spreadsheet programs
Zoho Sheet examples often use semicolon-separated formula arguments; do not paste Excel comma-separated formulas blindly. Some match semantics differ in wildcard and regex handling.
Related guides already published for this function: Microsoft Excel | Google Sheets | Collabora Office Calc | LibreOffice Calc | Calligra Sheets
If a comparison tool says Not researched here, that means we do not yet have a checked guide for that software. It does not mean the software lacks this function. See the 12-program comparison tool for a guide-coverage matrix.
Official reference and editorial verification
Evidence level: Vendor-published function catalogue / formula overview, checked for this editorial batch on October 11, 2026; example outputs verified by direct reasoning/arithmetic where applicable. No execution in Zoho Sheet was performed. Some platform-, language- and release-specific edge cases remain for native testing.