IF (condition1) THEN (result:=  ) ELSE IF (condition2) THEN (result:=  ) ELSE IF (condition3) ELSE (result:=  )

  • User can use any normal operators or formulas which can be insert in (condition) 

  • When the (condition1) is true, It will give the result in the first THEN(result:=) . If it is not true, It will go on checking in with (condition2) and display the second THEN(result) if (condition2)  is true.  

  • It will continue to check on each of the conditions and display the result in that order from left to right and if none are true, it will display the "ELSE(result:=)"   

Caution: Any of those THEN (result:=  ) the returned value will need to share the same type, being either a text or number, with the "inherited-from" property. The same for "ELSE(result:=)"

Example: if a equals 10 then d will display "It is 10". If a equals 20 then d will display "It is 20". If a equals 30 then d will display "It is 30". If not, the final result is "No result"