Help with an IF statement.

[WRevera]

My boss needs a new check sheet for the picking and packing department. I've got so far with it and im absolutely stuck!

I need an automatic calculation on the service dependant on two things, the Courier chosen, and the Weight of the parcel. I have solved the first courrier but when I try to add the second into the IF statement shown, it jsut brings up false, im not the best at excel and could do with a hand!

=IF(I10="UPS",IF(H10=1,"ExPac 1",IF(AND(H10>1,H10<=5),"ExPac 5",IF(AND(H10>5,H10<=30),"Parcel",IF(AND(H10>30,H10<70),"Freight",IF(I10="Target",IF(H10=1,"Target 1")))))))

It works right up to the IF statement before target...

Help...

[shg]

Welcome to the forum.

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

Thanks.

[WRevera]

I have attached my worksheet.. Thanks for any assistance...


W Revera

[WRevera]

Any advice?

[DonkeyOte]

Your thread title is still not acceptable I'm afraid...

Perhaps along the lines of: Establishing Service Type with Conditions

[jj72uk]

Answer ready for upload...