IfNA-func
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.
string IfNA(double val, string val_na$)$
val
val_na$
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 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"