# adding delivery cost if less than 15 items are delivered

1. ## 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

2. ## 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:
`Please Login or Register  to view this content.`

Change the range C2:C14 to match your actual range of numbers of each item.

Many thanks

5. ## Re: adding delivery cost if less than 15 items are delivered

You're welcome, glad I could help.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1