Skip to main content

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

  • Users can use any normal operators or formulas which can be inserted 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:=)"

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".

PlanSwift Formulas Advanced IF THEN ELSE Statement

click here to view the previous article Advanced IF - THEN - ELSE Statements Nested Formulas click here to view the next article

Related Articles

Be the first to reply!
Terms & ConditionsCookie settingsAccessibility statement