+ Reply to Thread
Results 1 to 5 of 5

adding delivery cost if less than 15 items are delivered

  1. 07-09-2019, 06:57 AM #1
    Tacknow
    Tacknow is offline
    Registered User
    Join Date
    01-22-2014
    Location
    Ireland
    MS-Off Ver
    Excel 2007
    Posts
    23

    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
    Reply With QuoteRegister To Reply
  2. 07-09-2019, 07:43 AM #2
    Aardigspook
    Aardigspook is offline
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,405

    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

    I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - 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.
    Reply With QuoteRegister To Reply
  3. 07-09-2019, 08:35 AM #3
    Tacknow
    Tacknow is offline
    Registered User
    Join Date
    01-22-2014
    Location
    Ireland
    MS-Off Ver
    Excel 2007
    Posts
    23

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

    Many thanks
    Reply With QuoteRegister To Reply
  4. 07-09-2019, 08:35 AM #4
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,398

    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!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  5. 07-09-2019, 01:44 PM #5
    Aardigspook
    Aardigspook is offline
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,405

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

    You're welcome, glad I could help.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel Assigning Value In Table Problem ( Shifting Problem )
    By Nefiskenar in forum Excel General
    Replies: 6
    Last Post: 07-01-2018, 01:58 PM
  2. [SOLVED] Excel Macro - Copy & Paste (Font) problem & Delete Last Added Rows problem
    By LennartB in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-05-2015, 06:58 AM
  3. Excel Problem with worksheet, need to know which function for penny a day doubled problem
    By excellhobo in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-20-2013, 07:16 PM
  4. input box problem, cell filtering problem, result display while locking sheet
    By croozin in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-01-2013, 08:52 AM
  5. Index / Match / Vlookup type problem - £20 to person who solves this! X ref problem
    By aceparts in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-28-2013, 05:08 PM
  6. Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
    By Emsky in forum Excel General
    Replies: 2
    Last Post: 01-22-2013, 07:09 AM
  7. Problem using formulas within macro + problem with defined name.
    By rain4u in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-11-2011, 04:39 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1