Returns true value or false value from a condition.
If(condition,true value,false value)
condition can be any valid expression which performs a comparison, such as Amount>1000 or Quantity*Price=Total.
true value is the value returned if the condition is true.
false value is the value returned if the condition is false.
This function may return a number, a date or a character string.
Calculated field example
To create a Sale_price field that calculates a 20% discount off quantities of 5 or more, use the expression: If(Quantity>=5,Amount*0.80,Amount)
Quantity>=5 comparison expression: If the quantity is greater than or equal to 5, the function returns Amount*0.80, representing a 20% discount. For quantities less than 5, the function returns the full Amount field value, representing no discount.
The If() function has no practical application in filter or find expressions.