=IF(MOD(A2,10)=6,A2+4,A2+11)
--
David Biddulph

"Mark Toulson" wrote in message
...
What is the formula I can use to calculate the next number in an range of
airline MAWBs. The formula needs to add 11 to each number, ie 46832952,
unless the 8 digit number ends in 6, then the formula needs to add 4.

Thanks