if (function)

Question

Can some one explain how the below function evaluates, appreciate your help in advance!! 
 if(true, false, false, true, false, 30, 40)

Mike Schmitt · Accepted Answer

the if() function can handle if/else if/else functionality inherently. If given more than 3 parameters (if/then/else), the subsequent odd-numbered parameters [except the final one] will each be evaluated as a new condition. 
 if(
 ri!colorIndex = 1,
 "Red",
 
 ri!colorIndex = 2,
 "Green",
 
 ri!colorIndex = 3,
 "Blue",
 
 "Something else..."
) 
 For example, the above code will evaluate to "Red" for an input of 1, "Green" for an input of 2, "Blue" for an input of 3, and for any other input value, it will return the default return value of "Something else..." 
 NOTE : as mentioned down-thread, this functionality is not officially supported or documented, so use it with caution if at all. (/edit)

Robert Shankin · Answer

Unknown said: if(true, false, false, true, false, 30, 40) 
 This will return false. 
 The function evaluates the first input - In your case this is "true". Since it evaluates to true, it returns the 2nd input. The 3rd input would be returned if the 1st input evaluated to false. 
 test this by changing the second input from "false" to "Appian"

if (function)

Top Replies