Content

Web Calculator with Volume Discounts - Easy with Calculoid!

What is a better way to persuade your client to make a purchase of a larger quantity of your product than offer a volume discount

 

With Calculoid's IF formula, you can implement volume discounting right into your calculator! 

The logic behind IF formula

IF formula allows you to set a condition under which a certain price would apply. Just like in Excel you can set a certain discount or price per product to apply to a certain quantity. So, if client orders over 500 items, the discount can be 5%, on a purchase over 1000 items, a discount of 10% would apply - this is known as volume discounting.

General format of IF formula in Calculoid is if (condition, true, false)

Example Calculator with Volume Discounting

Below you can see volume discounting scheme for a wholesale Tea Online store:

<=500kg 0%
 >=500kg 5% 
 >=1000kg 10% 
>=2000kg 15%
>=3000kg Custom offer

 

Every band would require its own IF condition and it will follow this logical order:

=<500 ...  if(FIELD=<500, 0, ...

<1000 ...    if(FIELD<1000, 5%,...

<2000 ...  if(FIELD>1000, 10%...

The last condition, >2000kg, is not necessary to include since this discount will be applied in all cases that are not already covered by conditions of this formula. 

The formula looks like:

if(FIELD=<500, 0, if(FIELD<1000, 5%, if(FIELD<2000, 10%, 15%)

Calculoid Blog Formula Field
*how it looks like in the editor

How it looks in practice

link to this calculator: https://app.calculoid.com/?#/calculator/40091

 

 

 

 

Additional information

Start Free Trial

Create your own web calculator in a matter of minutes.
Test all features in the 14-day free trial. 

Start Free Now

No credit card or installation needed

 

Contact us

Phone

+1 415 800 3787

Information

info@calculoid.com

Support

support@calculoid.com

Easy Software Ltd.

Kemp House, 152-160
City Road, EC1V
2NX London, United Kingdom
Company ID: 08960980
VAT ID: GB226711521

Easy development center

Jugoslávských partyzánů 34
160 00 Prague
Czech Republic