# Thread: Formula tidying/amending (2003 sp2)

1. ## Formula tidying/amending (2003 sp2)

Hi Guys (non gender specific)

=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

2. ## 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?

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

4. ## Re: Formula tidying/amending (2003 sp2)

Does the attached do what you want?

5. ## Re: Formula tidying/amending (2003 sp2)

Hi Legare

Thats great, thanks for the time and effort

Steve

#### Posting Permissions

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