• esProc
Tutorial
Function Reference
User Reference
External Library Guide
Data File Tool Manual
DQL Tutorial
Cluster Server Manager Manual
SPL WIN Manual
• YModel
User Reference
JSON-style Parameter Guide
• ReportLite
User Reference
• Official Website

# if()

Read（2301）

Description:

Calculate boolean expressions from left to right. if the result is true, return true value; otherwise return default value or false value.

Syntax:

 if(a) If a is true, then return true. Otherwise, return false if(a,b,c) If a is non-null and non-false, then return b; otherwise return c, which is null by default. if(x1:y1,…,xk:yk;y) Equivalent to if(x1,y1,if(x2,y2,…,if(xk,yk,y)))

Note:

This function calculates from left to right, and returns different values based on the different results of computing the boolean expressions. Return the corresponding result for the first expression whose value is true and ignore other boolean expressions. If none of the boolean expression has true value, but there is a default value expression, then return the default value; if there is no such a default value expression, return null.

Parameter:

 a Boolean expression b Value expression. If a is true, then return the result of b c Value expression. If a is false, then return the result of c xk Boolean expression yk Value expression. If xk is true, then return its result y Default value expression. If all the results of boolean expressions are false, then return the result of this expression

Return value:

Determined by the result of value expression

Example:

 A 1 =if(2>1,"Truth","Fallacy") Truth 2 =85 3 =if(A2>90:"Excellent",A2>80:"Good",A2>60:"Passed";"Failed") Good 4 >A2=300 5 =if(A2>100:,A2>90:"Excellent",A2>80:"Good",A2>60:"Passed";"Failed") null 6 =if(A2>100) true

Related function: