Total : 0.00 €

Before contacting us, please make sure to check our F.A.Q

Please, login or register to our website in order to be able to post a presale question in the forum.

# multiple price conditions in one formula

2 years 6 months ago #1773 by Paul
Paul replied the topic: multiple price conditions in one formula
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: altoswebsolutions.com/contact-us

We will be waiting for your feedback

Best regards
Paul
AT719

2 years 6 months ago #1771 by jonm
jonm replied the topic: multiple price conditions in one formula
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

2 years 6 months ago #1770 by Paul
Paul replied the topic: multiple price conditions in one formula
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: 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

2 years 6 months ago #1768 by jonm
jonm created the topic: multiple price conditions in one formula
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