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%)

*how it looks like in the editor