# IFNA

## Content

This function calculates the specified value if the formula returns #N/A error, otherwise it returns the actual result of the formula.

## Syntax

`IFNA(value, value_if_na)`

## Arguments

This function has the following arguments:

| Argument | Description |
| -------- | ----------- |
| *value* | Refers to a number, or expression that needs to be tested |
| *value\_if\_na* | Refers to an alternate number, or expression that is returned if*value*returns #N/A error |

## Remarks

If *value* or *value\_if\_na* is empty, IFNA treats it as an empty string value ("").

## Data Types

Accepts numeric, string (or any expression) data for both arguments.

## Examples

`IFNA(VLOOKUP("Sweden",$A$6:$B$8,0),"Not found")` gives the result Not found.