3.5.1.7.10 IfNA

Description

Minimum Origin Version Required: 2019 SR0

Evaluate the given val and return the specified val_na if val is missing, otherwise return val.

Syntax

string IfNA(double val, string val_na$)$
double ifNA(double val, double val_na)

Parameters

val

The value used to determine whether to return the specified string or not

val_na

Can be string or double, the string or numeric to return if the result of formula val is missing value

Return

IfNA(val, val_na$)$ will return the specified string vail_na$ if the result of the given value val is missing, otherwise return the string display of val.

IfNA(val, val_na) will return the specified numeric val_na if the result of the given value val is missing, otherwise return the value of val.

Example

Example 1

Fill some data in column A and B. In column C, enter

IfNA(col(A)/col(B),"missing")$

in F(x) header row. It will fill column with string value of col(A)/col(B), if the result is missing, fill that row with "missing"

Ifna example1.png

Example 2

ifNA(C,1E10)

Ifna example2.png