Goal
Learn how to use the IF function to create an IF THEN ELSE statement.
Learn
The IF function has the following syntax:
IF( <this is #true>; <then #do()>; <else #do()>)
Example 1
IF( (#Example!Input <= 5); (#Example!Input + 1) ; (#Example!Input - 1) )
Example 2
IF(CONTAINS(#Input; "words"); "yes"; "no")
Example 3
IF( CONTAINS(#Input; "words"); REPLACEALL(#Input; "words"; "text"); (#Input))
Further Information
Please have also a look into our Community thread How can I 'pipe' or 'join' multiple formulas so I can do several IF statements?.
Comments
0 comments
Please sign in to leave a comment.