IFNA Function is used when a formula returns #N/A Error. in Place of the #N/A Error you can show predefined Value.
Syntax
=IFNA(Value, Value if na)
Arguments
Value: The value reference or a formula to test for error
Value if na: returns Predefined value when #N/A Error found
Behavior
Here we have taken an example of the month and its figure.
Now we use VLOOKUP function to create #N/A Error. In the F column, it will show #N/A error.
Now we use IFNA Function as shown in the above figure which will replace #N/A error to "NOT AVAILABLE"
Usage
IFNA is used for to find #N/A error and replace with predefined value
Returns
IFNA returns predefined value as #N/A error found
No comments:
Post a Comment