IFNA Function

how to use ifna function in excel

IFNA Function is used when a formula returns #N/A Error. in Place of the #N/A Error you can show predefined Value.


=IFNA(Value, Value if na)


Value: The value reference or a formula to test for error
Value if na: returns Predefined value when #N/A Error found


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"


IFNA is used for to find #N/A error and replace with predefined value


IFNA returns predefined value as #N/A error found

No comments:

Post a Comment