| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating Date Ranges | Excel Worksheet Functions | |||
| Calculating the number of values between specified ranges | Excel Discussion (Misc queries) | |||
| Calculating rate based on age ranges | Excel Worksheet Functions | |||
| Calculating with named ranges | Excel Discussion (Misc queries) | |||
| calculating date time ranges | Excel Worksheet Functions | |||
![David Biddulph[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
