Thanks for your help.
As i was struggling with this code, my colleague helped me with another formula:

Code:
=IF(C30<=3302000000,"DXB",IF(C30<3303000000,"AUH",IF(C30<3304000000,"Al Ain",IF(C30<3305000000,"SHJ",IF(C30<3307000000,"RAK",IF(C30<3308000000,"AJM",IF(C30<3309000000,"FUJ","Others")))))))
and it works fine too. Thanks for the help on splittin the data too.