How to create flexible discounts in the calculator formula

Not sure how to have the calculator apply these discounts:

If two values are selected, a discount of 10% is applied. If three values are selected, a 15% discount is applied. If four or more values are selected, a 18% discount is applied.

I used the Ai calculator generator and it didn’t work:

IF(SUM({{a1b2c3d4}}) EQUAL 2, {{d5e6f7g8}} * 0.1, IF(SUM({{a1b2c3d4}}) EQUAL 3, {{d5e6f7g8}} * 0.15, IF(SUM({{a1b2c3d4}}) >= 4, {{d5e6f7g8}} * 0.18, 0)))

3 Likes

Hi there, @user16663 and welcome to the Community :wave:

I’ve passed your request on to the dev team and will let you know once the formula is ready :slightly_smiling_face:

Hi there, @user16663 :wave:

We’ve created this formula and saved it in your widget:


Please check it out and let me know if you like how it works :slightly_smiling_face:

Thanks this works great! Love your site.

2 Likes

Perfect, thank you so much for the feedback :wink:

In the meantime, I’d like to remind you about our Giveaway, where you can win 3 FREE months for your subscription.

Check the details and join in - April Giveaway: Celebrate 80K Members with Us & Win 3 FREE Months! :heart_eyes: