Excel公式——手机号区分运营商归属，电信，联通，移动手机号的区分

=IF(LEFT(A2,3)="134","移动",IF(LEFT(A2,3)="135","移动",IF(LEFT(A2,3)="136","移动",IF(LEFT(A2,3)="137","移动",IF(LEFT(A2,3)="138","移动",IF(LEFT(A2,3)="139","移动",IF(LEFT(A2,3)="147","移动",IF(LEFT(A2,3)="150","移动",IF(LEFT(A2,3)="151","移动",IF(LEFT(A2,3)="152","移动",IF(LEFT(A2,3)="157","移动",IF(LEFT(A2,3)="158","移动",IF(LEFT(A2,3)="159","移动",IF(LEFT(A2,3)="182","移动",IF(LEFT(A2,3)="183","移动",IF(LEFT(A2,3)="187","移动",IF(LEFT(A2,3)="188","移动",IF(LEFT(A2,3)="130","联通",IF(LEFT(A2,3)="131","联通",IF(LEFT(A2,3)="132","联通",IF(LEFT(A2,3)="155","联通",IF(LEFT(A2,3)="156","联通",IF(LEFT(A2,3)="185","联通",IF(LEFT(A2,3)="186","联通",IF(LEFT(A2,3)="145","联通",IF(LEFT(A2,3)="133","电信",IF(LEFT(A2,3)="153","电信",IF(LEFT(A2,3)="180","电信",IF(LEFT(A2,3)="189","电信",IF(LEFT(A2,3)="181","电信",IF(LEFT(A2,3)="177","电信","")))))))))))))))))))))))))))))))

 

 

手机号在A列，该公式放在第二行，然后下拉

 

转载于:https://www.cnblogs.com/zhangningfengcnblogs/p/4450411.html