# adding delivery cost if less than 15 items are delivered

• 07-09-2019, 06:57 AM
Tacknow
adding delivery cost if less than 15 items are delivered
Hi Infrequent User need some help.

If the delivery of items is more than 0 but less than 15 a delivery charge applies.

If the sum of a number of cells is more than 0 but less than 15 cell =1 if not cell equals 0

Cost
item 1 €25.00 1 €25.00
item 2 €25.00 2 €50.00
item 3 €25.00 3 €75.00
item 4 €25.00 4 €100.00
item 5 €25.00 5 €125.00
item 6 €25.00 6 €150.00
item 7 €25.00 7 €175.00
item 8 €25.00 8 €200.00
item 9 €25.00 9 €225.00
item 10 €25.00 10 €250.00
item 11 €25.00 11 €275.00
item 12 €25.00 12 €300.00
item 13 €25.00 13 €325.00
Del Charge €75.00 1 €75.00

Cost
item 1 €25.00 0 €0.00
item 2 €25.00 2 €50.00
item 3 €25.00 0 €0.00
item 4 €25.00 1 €25.00
item 5 €25.00 0 €0.00
item 6 €25.00 2 €50.00
item 7 €25.00 0 €0.00
item 8 €25.00 0 €0.00
item 9 €25.00 1 €25.00
item 10 €25.00 2 €50.00
item 11 €25.00 1 €25.00
item 12 €25.00 1 €25.00
item 13 €25.00 1 €25.00
Del Charge €75.00 0 €0.00

• 07-09-2019, 07:43 AM
Aardigspook
Re: adding delivery cost if less than 15 items are delivered
Welcome to the forum.

Put this in the cell where you want the 1 or 0:
Formula:
`=IF(SUM(C2:C14)<15,0,1)`

Change the range C2:C14 to match your actual range of numbers of each item.
• 07-09-2019, 08:35 AM
Tacknow
Re: adding delivery cost if less than 15 items are delivered
Many thanks
• 07-09-2019, 08:35 AM
AliGW
Re: adding delivery cost if less than 15 items are delivered