| Name | Brief | Example |
|---|---|---|
| BitAND(int a, int b) | Returns bitwise AND operation of two integers. | Example |
| BitOR(int a, int b) | Returns bitwise OR operation of two integers. | Example |
| BitXOR | Returns bitwise XOR operation of two integers. | 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 |
| xor(n1,n2) | Returns XOR operation of two logical values n1 and n2. | Example |