Embedded Files
Returns the first argument if it is not an #N/A error value, otherwise returns the second argument if present, or a blank if the second argument is absent.
How to use?
How to use?
SYNTAX: =IFNA(value, [value_if_na_error])
value - The value to return if value itself is not an #N/A error.
value_if_na_error - [optional] - The value the function returns if value is an #N/A error.
PRACTICE SHEET
The above sheet is view only mode, please make a copy to practice.
Page updated
Google Sites
Report abuse