Iif()

Use the Iif() function to quickly test a condition. You pass the condition as the first parameter. The condition can be any function or expression that returns true or false. If the condition is true, the function returns the second parameter; if the condition is false, it returns the third parameter.

The Iif() function has three parameters:

  • condition (string): Required. The condition to test.
  • valueIfTrue (string): The value to return if the condition is true.
  • valueIfFalse (string): The value to return if the condition is false.

In this example, the function returns the value of the variable @VAR if the variable isn't empty, and returns "Hello" if the variable is empty.