IFNA practice

IFNA returns a replacement value only when a formula produces #N/A, the error a failed lookup gives. Below are the 1 Google Sheets exercise on Sheetsdrill that use it, each checked instantly in your browser.

Syntax

IFNA(value, value_if_na)

What people get wrong

Prefer it to IFERROR around lookups: a typo in the formula still shows as an error instead of being hidden.

Google Sheets exercise that use IFNA

• Zero instead of #N/ALevel 3Pro

Often used together with: VLOOKUP