3.5.1.6 Logical Functions

Name Brief Example
If(con,val_true$[,val_false$]$)
If(con,val_true[,val_false])
Return the specified values depending on the result of comparison. Example
Ifs(con1,d1[,con2,d2]...[,con40,d40])
Ifs(con1,str1$[,con2,str2$]...[,con40,str40$])$
Evaluate a value to multiple conditions, and return the corresponding value when the first TRUE condition is met. Example
IfNA(double value, string value_na$)$ Returns the specified string if the result of the given formula is missing, otherwise return the string display of the result of the formula. Example
Switch(expression,val1,res1[,val2,res2]...[,val39,res39][,default])
switch(expression,val1,res1$[,val2,res2]...[,val39,res39$][,default$])$
Compare a value expression to a set of values. If match is found, return the corresponding value. If no match is found, default value will be returned. Example