Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    Surrey, United Kingdom
    Posts
    1,001
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Formula tidying/amending (2003 sp2)

    Hi Guys (non gender specific)

    Could somebody please help with tidying this formula

    =SUM(A21*C21+B21+C2+C5+C8+C11+C14+C17-20)

    I have a tariff which is very simple, basically a shimpent of up to 10 kilos (a21) is charged a flat rate of 40.00 (b21), any weight above that is charged an additional amount per kilo, 2.00 per kilo (C21), (the rest of the cells are for 'add ons' to the basic service) although crude what I have above works unless a weight less than 10 kilos is entered, I tried playing about with Ceiling etc. but it is above my capabilities. The -20 at the end of the formula is because I cannot get the minium to work so what that is doing is subtracting the first 10 kilos because it is included in the minimum, I hope that makes some sort of sense.

    Cheers

    Steve

    And welcome back everybody
    Cheers

    Steve

    Asking the questions everbody wants the answers too but feels too stupid to ask themselves :-)

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formula tidying/amending (2003 sp2)

    Your formula does not make a lot of sense without seeing the worksheet and knowing exactly what is in ALL of those cells. Could you upload a sample workbook and explain what is in all of the cells used in the formula?
    Legare Coleman

  3. #3
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    Surrey, United Kingdom
    Posts
    1,001
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formula tidying/amending (2003 sp2)

    Hi Legare

    "Could you upload a sample workbook and explain what is in all of the cells used in the formula?"

    Thereby hangs another tale

    The workbook in question is 4 columns x 25 rows with very simple formulas but it is a massive 1.464kb and I cannot understand why, I am sure I read a tip from Hans once saying use the 'Save As' option but it does not make any difference. Sorry, I just had a quick thought and copied and pasted the info into a new blank workbook and hey presto 15kb, I can't quite understand why that could be? Anyway it is now attached.

    I would appreciate anybodies suggestions in makeing it look a bit better as well

    Thanks

    Steve
    Attached Files Attached Files
    Cheers

    Steve

    Asking the questions everbody wants the answers too but feels too stupid to ask themselves :-)

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formula tidying/amending (2003 sp2)

    Does the attached do what you want?
    Attached Files Attached Files
    Legare Coleman

  5. #5
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    Surrey, United Kingdom
    Posts
    1,001
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formula tidying/amending (2003 sp2)

    Hi Legare

    Thats great, thanks for the time and effort

    Steve
    Cheers

    Steve

    Asking the questions everbody wants the answers too but feels too stupid to ask themselves :-)

Posting Permissions

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