Hi Mckay, You can add as many coupon code as required with percentage or fixed discounts. Please note that the coupon codes are case sensitive.
Example formula with two discount codes
IFS(Coupon Code == "LOYAL10", 0.10 * Order Amount, Coupon Code == "WELCOME", 10,0)
IFS function:
Evaluates multiple conditions and returns a value that corresponds to the first true condition.
Syntax:
IFS(condition1, value1, condition2, value2, condition3, value3, … )
where
condition1 - The first condition to be evaluated.
value1 - The returned value if condition1 is TRUE.
condition2, value2, condition3, value3, … - Additional conditions and values if the first one is evaluated to be false.
Please try this and confirm
Comments (1)
Mar 27, 2024
Hi Mckay, You can add as many coupon code as required with percentage or fixed discounts. Please note that the coupon codes are case sensitive. Example formula with two discount codes IFS(Coupon Code == "LOYAL10", 0.10 * Order Amount, Coupon Code == "WELCOME", 10,0) IFS function: Evaluates multiple conditions and returns a value that corresponds to the first true condition. Syntax: IFS(condition1, value1, condition2, value2, condition3, value3, … ) where condition1 - The first condition to be evaluated. value1 - The returned value if condition1 is TRUE. condition2, value2, condition3, value3, … - Additional conditions and values if the first one is evaluated to be false. Please try this and confirm
Add your comment
Add photo