IfNA

Contents

Description

Minimum Origin Version Required: 2019 SR0

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

Syntax

string IfNA(double val, string val_na$)$

Parameters

val

The formula 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 formula is missing, otherwise return the string display of the result of the formula.

Example

Example 1

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

IfNA(col(A)/col(B),"not found")$

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