# IFNA

The IFNA function returns the value you specify if a formula returns the #N/A error value; otherwise, it returns the result of the formula.

## Syntax

```javascript
ifna(value1,value2)
```

## Arguments

value1- The argument that is checked for the #N/A error value

value2- The value to return if the formula evaluates to the #N/A error value

## **Return value**

Either value1 or value2

## **Example**

```javascript
ifna((AC-PY)/PY, 0)
```

Returns AC-PY/PY if the value is a number, else returns 0.

<figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2FsYw7E72HdW5M6SaE3ykD%2Fimage.png?alt=media&#x26;token=cda90895-256e-43ec-bf2c-b971cfda7cc3" alt=""><figcaption><p>IFNA example</p></figcaption></figure>

## **Excel equivalent**

[IFNA](https://support.microsoft.com/en-us/office/ifna-function-6626c961-a569-42fc-a49d-79b4951fd461)