Translations:Expressions/155/en
Syntax:
IF(<expression to be tested>; <expression if true>; <expression if false>)
Examples:
IF(BETWEEN("Value";0;100);10;250) - If Value is between 0 and 100 returns 10, if not 250 IF("Profit" == 0;0;"Profit" + "Taxes") - If Profit equals 0 returns 0, if it does not return the sum between Profit and Taxes IF("Product Code" == 3231;0;"Quantity" * 3;"Quantity") - If Product Code equals 3231 returns Quantity plus 3