+ Reply to Thread
Results 1 to 5 of 5

adding delivery cost if less than 15 items are delivered

  1. #1
    Registered User
    Join Date
    01-22-2014
    Location
    Ireland
    MS-Off Ver
    Excel 2007
    Posts
    9

    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


    Thanks in advance
    Last edited by Tacknow; 07-09-2019 at 07:15 AM. Reason: moderator advise

  2. #2
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily NL, sometimes UK
    MS-Off Ver
    2010
    Posts
    2,186

    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: copy to clipboard
    Please Login or Register  to view this content.


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

    My internet connection can be intermittent, so sometimes I may not reply quickly to questions. Sorry - it's not personal and I will reply eventually.
    If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
    If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
    You don't need to give me rep if I helped, but a thank-you is nice.

  3. #3
    Registered User
    Join Date
    01-22-2014
    Location
    Ireland
    MS-Off Ver
    Excel 2007
    Posts
    9

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

    Many thanks

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2016 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    30,408

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

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  5. #5
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily NL, sometimes UK
    MS-Off Ver
    2010
    Posts
    2,186

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

    You're welcome, glad I could help.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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