Google Sheets | IFNA Function | Display Message for
Use the Google Sheets IFNA function to check if a cell, or cell(s) in a range, has the #N/A error. If a cell has this error, the function can, for example, display a custom message, not display any message, or return a value from a cell. If a cell doesn't have the #N/A error, IFNA returns the data in the cell.
-------------------------------------
Google Sheets Quiz with Demo of Answers
Try this 5-question quiz, which also demos the answers. The quiz
can be helpful in your day-to-day spreadsheet work or for job interview:
• Google Sheets Functions Quiz | Fill-i...
If you wish to find the position of an item in a list, the MATCH function can
be helpful. Here is the link to the step-by-step tutorial on MATCH:
• Google Sheets Match | Match Function ...
-------------------------------------
Here is the format of the IFNA function formula:
=IFNA(value, [value_if_na_error])
Start the formula with an equal-to symbol.
IFNA is the name of the function.
value can be a cell address, range address, or function, and this value will be returned if the cell doesn't have the #N/A error.
value_if_na_error is optional, and is the value that the function returns in case of #N/A error. If this argument is omitted, the IFNA function does not display any message.
Let's look at an example of the IFNA function formula:
=IFNA(A15, "Data does not exist")
The above formula will return the value in the cell A15, if the formula in it
has not produced the #N/A error. Otherwise, it will return the message "Data does not exist".
Take a look at this video, which gives the steps to use the Google Sheets IFNA function with examples.