Hi this doesn't help however this is what I want it to do

Weight Type of Service Cost
(Culumn D) (Culumn E) (Column F)

Column D will be manually entered.

Column E will be one of the following:-
CP16, ND12, ND16, NS12, RD1 and RD2

Column F I want to have the formula which is what I'm trying to work out. I
want it to automatically know which formular to use depending what Column E's
cell says. I have wrote down what each code means.

CP16 = 6 with a maximum of 5kg

ND 12 = 13 for the first 10kg then .29 per 1kg for the next 100kg and then
..42 per 1kg for the next 999kg

ND16 = 7.25 for the first 15kg then 0.29 per 1kg for the next 100kg and then
..42 per 1kg for the next 999kg

NS12 = 33 for the first 10kg and then 0.29 per 1kg for the next 100kg and
then .42 per 1kg for the next 999kg

RD1 = 14.70 for then first 10kg then 0.29 per 1kg for the next 100kg and
then .42 per 1kg for the next 999kg

RD2 = 15.75 for the first 10kg and then 0.29 per 1kg for the next 100kg and
then .42 per 1kg for the next 999kg

I hope this helps you understand a little more

Please can you help me as I am really struggling with this email.