Glad it helped.
--
David Biddulph

"Mark Toulson" wrote in message
...
Perfect! Thank you.

"David Biddulph" wrote:

=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