# multiple price conditions in one formula

Home – SaaS Forums Presale questions Woo Price Calculator multiple price conditions in one formula

Viewing 4 posts - 1 through 4 (of 4 total)
• Author
Posts
• #4549
jonm
Participant

Hello,

I have a product that the requires height cm x width cm

Height in CM [aws_price_calc_1]
Width in CM [aws_price_calc_2]

(\$aws_price_calc_1*\$aws_price_calc_2)*0.0028

Is there a way to have different pricing for certain size brackets? Is it possible to do it with a single formula.

For example
between 0-5000 sq cm the pricing would be (\$aws_price_calc_1*\$aws_price_calc_2)*0.0038
between 5001-10000 sq cm the pricing would be (\$aws_price_calc_1*\$aws_price_calc_2)*0.0028
10000 + sq cm the pricing would be (\$aws_price_calc_1*\$aws_price_calc_2)*0.0020

Or, is there a way you can have a base product price of say \$25. Then when the min \$25 price is reached the formula (\$aws_price_calc_1*\$aws_price_calc_2)*0.0028 would replace the base pricing

Hopefully that makes sense ðŸ™‚

Kind Regards,

Jon

#4552
Paul
Participant

Hello

Yes, both are possible using the excel (PRO version WPC). Using some excel formulas as LOOKUP,MATCH,INDEX and IF.
In regards to your first question you can check this: https://exceljet.net/formula/lookup-value-between-two-numbers
It shows you how to check a value in a range of numbers.
In regards to your second question you can solve writing something like : IF((Height*Width)*0.0028>25;(Height*Width)*0.0028;25)

Let us know if you have more questions.

Best Regards
Paul
AT719

#4551
jonm
Participant

Many thanks for your response, Paul, greatly appreciated.

If I purchase the pro version, would you guys be able to supply an initial excell sheet as per the above request? That way I could see how it is setup and hopefully be able to produce my own from thereon.

Kind Regards,

Jon

#4550
Paul
Participant

Hello

Yes, sure. If you buy the plug-in we can make you an initial excel for you.
Write us again then when it’s done and send to us the access of your website here: https://altoswebsolutions.com/contact-us