calculating shipping table

I want to be able to set a formula to calculate the shipping cost, for example:
in b2 any number can be entered depedning on the weight.. so if its
1 ounce on b2 it will be $1.5 on g2
2 ounces on b2 it will be $2 on g2
3 ounces on b2 it will be $2.5 on g2
4 ounces on b2 it will be $3 on g2

all the way up to 30 ounces, so any number they enter from 1 to 30 it will give the set price for shipping
I have attached a my worksheet
Thank you in advance

So if F2 = 1 then G2 should be $1.5 is that right?

Will it be up to 1 ounce for $1.5 and from 1 to 2 ounces for $2 etc?

Dave H

Hi chubbychub,

You could just break it down to raw formula but it relies on the function =ROUNDUP() working on XL2003, try this -

Please Login or Register  to view this content.

I have based it on rounding uo to the nearest ounce (ie 0.67 would equal 1).

Hope that works for you if not I have provided the above and an alternative using =VLOOKUP in the attached.

Dave H

the vlookup works Dave H, thanks!!
one dumb question, where is the table that is looking or where the rates you have set?

Never mind, i see it, its all the way to the N column... thanks DaveH!!!! Thanks alot..really, you the greatest!!
I learned so much already!, this forums rocks!

Glad to help,

Cheers

Dave H

I think this forum is an education for all of us. Good luck.

Dave H