Loading…
Loading…
IFERROR replaces any error with a value you choose. IFNA only replaces #N/A, which is what lookups return when nothing matches, so real mistakes still show.
Syntax
IFERROR(value, value_if_error) · IFNA(value, value_if_na)
Read the lesson, then try it yourself in a live spreadsheet.