# IFNA

Spread for WinForms provides advanced software components that support Excel import/export, full cell customization, an extensive calculation engine with over 450 functions and more, all with zero dependencies on Excel.

## 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.

## Version Available

This function is available in Spread for Windows Forms 11.0 or later.