ExcelBanter - Calculating Airline MAWB Ranges

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Calculating Airline MAWB Ranges (https://www.excelbanter.com/excel-discussion-misc-queries/187505-calculating-airline-mawb-ranges.html)

Mark Toulson

Calculating Airline MAWB Ranges

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

David Biddulph[_2_]

Calculating Airline MAWB Ranges

=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

Mark Toulson

Calculating Airline MAWB Ranges

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

David Biddulph[_2_]

Calculating Airline MAWB Ranges

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

All times are GMT +1. The time now is 03:52 AM.