3.5.1.7.10 IfNA

Description

Minimum Origin Version Required: 2019 SR0

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

Syntax

string IfNA(double val, string val_na$)$

Parameters

val

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

val_na$

the string to return if the result of formula val is missing value

Return

Return the specified string if the result of the given value is missing, otherwise return the string display of the value.

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