Hey all,

I have to check that thousands of manually entered FedEx airbills are accurate. I got a solution from Yahoo Answers of all places. The check system is similar to the passenger airline check system but a little more complicated.

Basically you have a 12 digit tracking number with FedEx Express. The 12th digit is a the check digit. You start with the 11th and work backwords multiplying each by 1 or 3 or 7 in that order and summing the products. You then take the modulus of 11 of the total at the end and this is your check digit. If the modulus of 11 equals 10 then the check digit is 0 so I just added another modulus of 10 to account for that.

The formula is below assuming E2 contains ONLY your 12 digit FedEx Express tracking number.

=IF(MOD(MOD(((MID(E2,11,1)+0)*1)+((MID(E2,10,1)+0)*3)+((MID(E2,9,1)+0)*7)+((MID(E2,8,1)+0)*1)+((MID(E2,7,1)+0)*3)+((MID(E2,6,1)+0)*7)+((MID(E2,5,1)+0)*1)+((MID(E2,4,1)+0)*3)+((MID(E2,3,1)+0)*7)+((MID(E2,2,1)+0)*1)+((LEFT(E2,1)+0)*3),11),10)=RIGHT(E2,1)+0,"OK","ERR")

Hope this helps someone else out as it has me.