# 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* | [Required] Refers to a number, or expression that needs to be tested |
| *value\_if\_na* | [Required] 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 ("").

## Examples

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