IFNA: How to Parse Address Components in Google Sheets

Use IFNA to parse address components in Google Sheets. Complete tutorial with syntax and examples.

Syntax

IFNA(value, value_if_na)

How to Parse Address Components

Evaluates a value. If the value is an #N/A error, returns the specified value. To parse address components, combine IFNA with the right arguments for your dataset.

Expert Tips

More specific than IFERROR — only catches #N/A, not other errors.

Get a Free Quote →