Skip to main content

IF (condition1) AND (condition2) THEN (result:= )

  • If (condition1) AND (condition2): those conditions are the same as the basic if-then statement condition; users can use normal operators and formulas here.

Both of the conditions have to be true before it gives the result; otherwise, it will look for another alternative result that requires an Else statement.

If (0<[property1]) and ([property1]<10)

If ('[property1]' = 'Text') and ([property2]<10)

If ('[property1]' = 'Text1') and ('[property2]'='Text2')

  • Then (result:=): This is the result of the if statement when both of the above conditions are true.

The returned value for the result will need to share the same type, being either a text or number, with the "inherited-from" property.

Then (result:=[property])

Then (result:='[property]') (if the property type is a text)

Then (result:=[property]-10) (if property type is a number)

Example 1: if a equals 10 and b equals 20 then d will be 10

PlanSwift Formulas Basic IF-THEN with multiple Conditions example 1

Example 2: if a equal 10 and b is "text" then d will display "It is correct"

PlanSwift Formulas Basic IF-THEN with multiple Conditions example 2

IF (condition1) OR (condition2) THEN (result:= )

  • If (condition1) OR (condition2): Those conditions are the same as the basic if-then statement condition; users can use normal operators and formulas here.

Keep in mind: EITHER one of the conditions has to be true; it will give the result. Otherwise it will look for another alternative result that requires an Else statement.

If ([property1]=10) or ([property1]<10)

If ('[property1] = 'Text') or ([property2]<10)

If ('[property1]' = 'Text1') or ('[property2]'='Text2')

  • Then (result:=): This is the result of the if statement when EITHER one of the above conditions or BOTH are true.

The returned value for the result will need to share the same type, being either a text or number, with the "inherited-from" property.

Then (result:=[property])

Then (result:='[property]') (if the property type is a text)

Then (result:=[property]-10) (if property type is a number)

Example 1: either a equals 10 or b is "text". d will display "It is correct"

PlanSwift Formulas Basic IF-THEN with multiple Conditions example 3

Example 2: either a is a number smaller than 10 or b is text . d will display "It is correct"

PlanSwift Formulas Basic IF-THEN with multiple Conditions example 4

click here to view the previous article Basic IF - THEN Statement Advanced IF - THEN Statement click here to view the next article

Related Articles

Be the first to reply!
Terms & ConditionsCookie settingsAccessibility statement