'''IF(BETWEEN("Value";0;100);10;250)''' - If ''Value'' is between ''0'' and ''100'' returns ''10'', if not ''250''
'''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
Latest revision as of 14:25, 19 November 2020
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 250IF("Profit" == 0;0;"Profit" + "Taxes") - If Profit equals 0 returns 0, if it does not return the sum between Profit and TaxesIF("Product Code" == 3231;0;"Quantity" * 3;"Quantity") - If Product Code equals 3231 returns Quantity plus 3