Excel中用IF函数判断工资薪级

岗位工资201807

=IF(A1="五","3405",)&IF(A1="六","3005",)&IF(A1="七","2773",)&IF(A1="八","2440",)&IF(A1="九","2174",)&IF(A1="十","2007",)&IF(A1="十一","1819",)&IF(A1="十二","1797",)&IF(A1="十三","1675",)

=IF(A1=3405,"五",)&IF(A1=3005,"六",)&IF(A1=2773,"七",)&IF(A1=2440,"八",)&IF(A1=2174,"九",)&IF(A1=2007,"十",)&IF(A1=1819,"十一",)&IF(A1=1797,"十二",)&IF(A1=1675,"十三",)

薪级工资201807

=IF(A2=2,"317",)&IF(A2=3,"346",)&IF(A2=4,"375",)&IF(A2=5,"409",)&IF(A2=6,"444",)&IF(A2=7,"484",)&IF(A2=8,"523",)&IF(A2=9,"569",)&IF(A2=10,"614",)&IF(A2=11,"665",)&IF(A2=12,"716",)&IF(A2=13,"767",)&IF(A2=14,"827",)&IF(A2=15,"887",)&IF(A2=16,"954",)&IF(A2=17,"1020",)&IF(A2=18,"1093",)&IF(A2=19,"1167",)&IF(A2=20,"1249",)&IF(A2=21,"1331",)&IF(A2=22,"1413",)&IF(A2=23,"1504",)&IF(A2=24,"1595",)&IF(A2=25,"1686",)&IF(A2=26,"1785",)&IF(A2=27,"1885",)&IF(A2=28,"1985",)&IF(A2=29,"2085",)&IF(A2=30,"2195",)&IF(A2=31,"2305",)&IF(A2=32,"2414",)&IF(A2=33,"2524",)&IF(A2=34,"2645",)&IF(A2=35,"2766",)&IF(A2=36,"2887",)&IF(A2=37,"3008",)&IF(A2=38,"3128",)&IF(A2=39,"3249",)&IF(A2=40,"3381",)&IF(A2=41,"3513",)&IF(A2=42,"3645",)&IF(A2=43,"3777",)&IF(A2=44,"3920",)&IF(A2=45,"4063",)

=IF(A1=317,"2",)&IF(A1=346,"3",)&IF(A1=375,"4",)&IF(A1=409,"5",)&IF(A1=444,"6",)&IF(A1=484,"7",)&IF(A1=523,"8",)&IF(A1=569,"9",)&IF(A1=614,"10",)&IF(A1=665,"11",)&IF(A1=716,"12",)&IF(A1=767,"13",)&IF(A1=827,"14",)&IF(A1=887,"15",)&IF(A1=954,"16",)&IF(A1=1020,"17",)&IF(A1=1093,"18",)&IF(A1=1167,"19",)&IF(A1=1249,"20",)&IF(A1=1331,"21",)&IF(A1=1413,"22",)&IF(A1=1504,"23",)&IF(A1=1595,"24",)&IF(A1=1686,"25",)&IF(A1=1785,"26",)&IF(A1=1885,"27",)&IF(A1=1985,"28",)&IF(A1=2085,"29",)&IF(A1=2195,"30",)&IF(A1=2305,"31",)&IF(A1=2414,"32",)&IF(A1=2524,"33",)&IF(A1=2645,"34",)&IF(A1=2766,"35",)&IF(A1=2887,"36",)&IF(A1=3008,"37",)&IF(A1=3128,"38",)&IF(A1=3249,"39",)&IF(A1=3381,"40",)&IF(A1=3513,"41",)&IF(A1=3645,"42",)&IF(A1=3777,"43",)&IF(A1=3920,"44",)&IF(A1=4063,"45",)

岗位工资201611

=IF(A1="五","2937",)&IF(A1="六","2662",)&IF(A1="七","2431",)&IF(A1="八","2145",)&IF(A1="九","1881",)&IF(A1="十","1760",)&IF(A1="十一","1661",)&IF(A1="十二","1639",)&IF(A1="十三","1529",)

=IF(A1=2937,"五",)&IF(A1=2662,"六",)&IF(A1=2431,"七",)&IF(A1=2145,"八",)&IF(A1=1881,"九",)&IF(A1=1760,"十",)&IF(A1=1661,"十一",)&IF(A1=1639,"十二",)&IF(A1=1529,"十三",)

薪级工资201611

=IF(A2=2,"260",)&IF(A2=3,"286",)&IF(A2=4,"313",)&IF(A2=5,"343",)&IF(A2=6,"372",)&IF(A2=7,"406",)&IF(A2=8,"440",)&IF(A2=9,"480",)&IF(A2=10,"520",)&IF(A2=11,"565",)&IF(A2=12,"615",)&IF(A2=13,"666",)&IF(A2=14,"723",)&IF(A2=15,"780",)&IF(A2=16,"844",)&IF(A2=17,"908",)&IF(A2=18,"979",)&IF(A2=19,"1051",)&IF(A2=20,"1130",)&IF(A2=21,"1209",)&IF(A2=22,"1289",)&IF(A2=23,"1377",)&IF(A2=24,"1465",)&IF(A2=25,"1553",)&IF(A2=26,"1649",)&IF(A2=27,"1746",)&IF(A2=28,"1843",)&IF(A2=29,"1940",)&IF(A2=30,"2046",)&IF(A2=31,"2153",)&IF(A2=32,"2260",)&IF(A2=33,"2367",)&IF(A2=34,"2483",)&IF(A2=35,"2600",)&IF(A2=36,"2716",)&IF(A2=37,"2833",)&IF(A2=38,"2950",)&IF(A2=39,"3066",)&IF(A2=40,"3194",)&IF(A2=41,"3321",)&IF(A2=42,"3449",)&IF(A2=43,"3577",)&IF(A2=44,"3704",)

=IF(A1=260,"2",)&IF(A1=286,"3",)&IF(A1=313,"4",)&IF(A1=343,"5",)&IF(A1=372,"6",)&IF(A1=406,"7",)&IF(A1=440,"8",)&IF(A1=480,"9",)&IF(A1=520,"10",)&IF(A1=565,"11",)&IF(A1=615,"12",)&IF(A1=666,"13",)&IF(A1=723,"14",)&IF(A1=780,"15",)&IF(A1=844,"16",)&IF(A1=908,"17",)&IF(A1=979,"18",)&IF(A1=1051,"19",)&IF(A1=1130,"20",)&IF(A1=1209,"21",)&IF(A1=1289,"22",)&IF(A1=1377,"23",)&IF(A1=1465,"24",)&IF(A1=1553,"25",)&IF(A1=1649,"26",)&IF(A1=1746,"27",)&IF(A1=1843,"28",)&IF(A1=1940,"29",)&IF(A1=2046,"30",)&IF(A1=2153,"31",)&IF(A1=2260,"32",)&IF(A1=2367,"33",)&IF(A1=2483,"34",)&IF(A1=2600,"35",)&IF(A1=2716,"36",)&IF(A1=2833,"37",)&IF(A1=2950,"38",)&IF(A1=3066,"39",)&IF(A1=3194,"40",)&IF(A1=3321,"41",)&IF(A1=3449,"42",)&IF(A1=3577,"43",)&IF(A1=3704,"44",)&IF(A1=3832,"45",)

基础绩效201611

=IF(A1="五","2340",)&IF(A1="六","2270",)&IF(A1="七","2190",)&IF(A1="八","2130",)&IF(A1="九","2100",)&IF(A1="十","2060",)&IF(A1="十一","1920",)&IF(A1="十二","1830",)&IF(A1="十三","1730",)

=IF(A1=2340,"五",)&IF(A1=2270,"六",)&IF(A1=2190,"七",)&IF(A1=2130,"八",)&IF(A1=2100,"九",)&IF(A1=2060,"十",)&IF(A1=1920,"十一",)&IF(A1=1830,"十二",)&IF(A1=1730,"十三",)

基础绩效201607

=IF(A1=2550,"五",)&IF(A1=2460,"六",)&IF(A1=2370,"七",)&IF(A1=2300,"八",)&IF(A1=2250,"九",)&IF(A1=2200,"十",)&IF(A1=2040,"十一",)&IF(A1=1940,"十二",)&IF(A1=1830,"十三",)

=IF(A1="五","2550",)&IF(A1="六","2460",)&IF(A1="七","2370",)&IF(A1="八","2300",)&IF(A1="九","2250",)&IF(A1="十","2200",)&IF(A1="十一","2040",)&IF(A1="十二","1940",)&IF(A1="十三","1830",)

-------------------------------------------------------------------------------------

岗位工资2015

=IF(A1=2266,"五",)&IF(A1=2079,"六",)&IF(A1=1936,"七",)&IF(A1=1705,"八",)&IF(A1=1623,"九",)&IF(A1=1529,"十",)&IF(A1=1408,"十一",)&IF(A1=1342,"十二",)&IF(A1=1265,"十三",)

=IF(A1="五","2266",)&IF(A1="六","2079",)&IF(A1="七","1936",)&IF(A1="八","1705",)&IF(A1="九","1623",)&IF(A1="十","1529",)&IF(A1="十一","1408",)&IF(A1="十二","1342",)&IF(A1="十三","1265",)

薪级工资2015

=IF(A1=207,"2",)&IF(A1=230,"3",)&IF(A1=253,"4",)&IF(A1=277,"5",)&IF(A1=303,"6",)&IF(A1=329,"7",)&IF(A1=360,"8",)&IF(A1=391,"9",)&IF(A1=426,"10",)&IF(A1=461,"11",)&IF(A1=502,"12",)&IF(A1=543,"13",)&IF(A1=589,"14",)&IF(A1=635,"15",)&IF(A1=681,"16",)&IF(A1=733,"17",)&IF(A1=785,"18",)&IF(A1=842,"19",)&IF(A1=899,"20",)&IF(A1=962,"21",)&IF(A1=1025,"22",)&IF(A1=1093,"23",)&IF(A1=1168,"24",)&IF(A1=1242,"25",)&IF(A1=1323,"26",)&IF(A1=1403,"27",)&IF(A1=1490,"28",)&IF(A1=1577,"29",)&IF(A1=1664,"30",)&IF(A1=1757,"31",)&IF(A1=1851,"32",)&IF(A1=1944,"33",)&IF(A1=2044,"34",)&IF(A1=2144,"35",)&IF(A1=2253,"36",)&IF(A1=2362,"37",)&IF(A1=2471,"38",)&IF(A1=2580,"39",)&IF(A1=2698,"40",)&IF(A1=2815,"41",)&IF(A1=2944,"42",)

=IF(A1=2,"207",)&IF(A1=3,"230",)&IF(A1=4,"253",)&IF(A1=5,"277",)&IF(A1=6,"303",)&IF(A1=7,"329",)&IF(A1=8,"360",)&IF(A1=9,"391",)&IF(A1=10,"426",)&IF(A1=11,"461",)&IF(A1=12,"502",)&IF(A1=13,"543",)&IF(A1=14,"589",)&IF(A1=15,"635",)&IF(A1=16,"681",)&IF(A1=17,"733",)&IF(A1=18,"785",)&IF(A1=19,"842",)&IF(A1=20,"899",)&IF(A1=21,"962",)&IF(A1=22,"1025",)&IF(A1=23,"1093",)&IF(A1=24,"1168",)&IF(A1=25,"1242",)&IF(A1=26,"1323",)&IF(A1=27,"1403",)&IF(A1=28,"1490",)&IF(A1=29,"1577",)&IF(A1=30,"1664",)&IF(A1=31,"1757",)&IF(A1=32,"1851",)&IF(A1=33,"1944",)&IF(A1=34,"2044",)&IF(A1=35,"2144",)&IF(A1=36,"2253",)&IF(A1=37,"2362",)&IF(A1=38,"2471",)&IF(A1=39,"2580",)&IF(A1=40,"2698",)&IF(A1=41,"2815",)&IF(A1=42,"2944",)

=IF(A1="2","207",)&IF(A1="3","230",)&IF(A1="4","253",)&IF(A1="5","277",)&IF(A1="6","303",)&IF(A1="7","329",)&IF(A1="8","360",)&IF(A1="9","391",)&IF(A1="10","426",)&IF(A1="11","461",)&IF(A1="12","502",)&IF(A1="13","543",)&IF(A1="14","589",)&IF(A1="15","635",)&IF(A1="16","681",)&IF(A1="17","733",)&IF(A1="18","785",)&IF(A1="19","842",)&IF(A1="20","899",)&IF(A1="21","962",)&IF(A1="22","1025",)&IF(A1="23","1093",)&IF(A1="24","1168",)&IF(A1="25","1242",)&IF(A1="26","1323",)&IF(A1="27","1403",)&IF(A1="28","1490",)&IF(A1="29","1577",)&IF(A1="30","1664",)&IF(A1="31","1757",)&IF(A1="32","1851",)&IF(A1="33","1944",)&IF(A1="34","2044",)&IF(A1="35","2144",)&IF(A1="36","2253",)&IF(A1="37","2362",)&IF(A1="38","2471",)&IF(A1="39","2580",)&IF(A1="40","2698",)&IF(A1="41","2815",)&IF(A1="42","2944",)

基础绩效2015

=IF(A1=1430,"五",)&IF(A1=1380,"六",)&IF(A1=1340,"七",)&IF(A1=1280,"八",)&IF(A1=1240,"九",)&IF(A1=1200,"十",)&IF(A1=1140,"十一",)&IF(A1=1080,"十二",)&IF(A1=1030,"十三",)

=IF(A1="五","1430",)&IF(A1="六","1380",)&IF(A1="七","1340",)&IF(A1="八","1280",)&IF(A1="九","1240",)&IF(A1="十","1200",)&IF(A1="十一","1140",)&IF(A1="十二","1080",)&IF(A1="十三","1030",)

生活补贴2015（同2014）

=IF(A1="五","1610",)&IF(A1="六","1610",)&IF(A1="七","1610",)&IF(A1="八","1435",)&IF(A1="九","1435",)&IF(A1="十","1435",)&IF(A1="十一","1246",)&IF(A1="十二","1246",)&IF(A1="十三","1176",)

=IF(A1=1610,"五",)&IF(A1=1610,"六",)&IF(A1=1610,"七",)&IF(A1=1435,"八",)&IF(A1=1435,"九",)&IF(A1=1435,"十",)&IF(A1=1246,"十一",)&IF(A1=1246,"十二",)&IF(A1=1176,"十三",)

----------------------------------------------------------------------------------

岗位工资（原）

=IF(A1=1298,"五",)&IF(A1=1144,"六",)&IF(A1=1023,"七",)&IF(A1=858,"八",)&IF(A1=803,"九",)&IF(A1=748,"十",)&IF(A1=682,"十一",)&IF(A1=649,"十二",)&IF(A1=605,"十三",)

=IF(A1="五","1298",)&IF(A1="六","1144",)&IF(A1="七","1023",)&IF(A1="八","858",)&IF(A1="九","803",)&IF(A1="十","748",)&IF(A1="十一","682",)&IF(A1="十二","649",)&IF(A1="十三","605",)

薪级工资（原）

=IF(A1=101,"2",)&IF(A1=113,"3",)&IF(A1=125,"4",)&IF(A1=138,"5",)&IF(A1=151,"6",)&IF(A1=167,"7",)&IF(A1=182,"8",)&IF(A1=200,"9",)&IF(A1=217,"10",)&IF(A1=237,"11",)&IF(A1=257,"12",)&IF(A1=279,"13",)&IF(A1=301,"14",)&IF(A1=325,"15",)&IF(A1=349,"16",)&IF(A1=376,"17",)&IF(A1=402,"18",)&IF(A1=431,"19",)&IF(A1=459,"20",)&IF(A1=488,"21",)&IF(A1=519,"22",)&IF(A1=549,"23",)&IF(A1=580,"24",)&IF(A1=611,"25",)&IF(A1=642,"26",)&IF(A1=675,"27",)&IF(A1=708,"28",)&IF(A1=741,"29",)&IF(A1=774,"30",)&IF(A1=809,"31",)&IF(A1=844,"32",)&IF(A1=879,"33",)&IF(A1=918,"34",)&IF(A1=956,"35",)&IF(A1=995,"36",)&IF(A1=1039,"37",)&IF(A1=1083,"38",)&IF(A1=1127,"39",)&IF(A1=1171,"40",)

基础绩效

=IF(A1="五","1490",)&IF(A1="六","1435",)&IF(A1="七","1380",)&IF(A1="八","1310",)&IF(A1="九","1255",)&IF(A1="十","1200",)&IF(A1="十一","1090",)&IF(A1="十二","1025",)&IF(A1="十三","960",)

201201新标准

=IF(A1="五级","1680",)&IF(A1="六级","1610",)&IF(A1="七级","1550",)&IF(A1="八级","1470",)&IF(A1="九级","1405",)&IF(A1="十级","1345",)&IF(A1="十一级","1230",)&IF(A1="十二级","1150",)&IF(A1="十三级","1080",)

201401新标准

=IF(A1="五","1830",)&IF(A1="六","1758",)&IF(A1="七","1696",)&IF(A1="八","1612",)&IF(A1="九","1545",)&IF(A1="十","1483",)&IF(A1="十一","1358",)&IF(A1="十二","1270",)&IF(A1="十三","1200",)

201401新标准--生活补贴

=IF(A1="五级","1610",)&IF(A1="六级","1610",)&IF(A1="七级","1610",)&IF(A1="八级","1435",)&IF(A1="九级","1435",)&IF(A1="十级","1435",)&IF(A1="十一级","1246",)&IF(A1="十二级","1246",)&IF(A1="十三级","1176",)

薪级工资（逆变）

=IF(A1=2,"101",)&IF(A1=3,"113",)&IF(A1=4,"125",)&IF(A1=5,"138",)&IF(A1=6,"151",)&IF(A1=7,"167",)&IF(A1=8,"182",)&IF(A1=9,"200",)&IF(A1=10,"217",)&IF(A1=11,"237",)&IF(A1=12,"257",)&IF(A1=13,"279",)&IF(A1=14,"301",)&IF(A1=15,"325",)&IF(A1=16,"349",)&IF(A1=17,"376",)&IF(A1=18,"402",)&IF(A1=19,"431",)&IF(A1=20,"459",)&IF(A1=21,"488",)&IF(A1=22,"519",)&IF(A1=23,"549",)&IF(A1=24,"580",)&IF(A1=25,"611",)&IF(A1=26,"642",)&IF(A1=27,"675",)&IF(A1=28,"708",)&IF(A1=29,"741",)&IF(A1=30,"774",)&IF(A1=31,"809",)&IF(A1=32,"844",)&IF(A1=33,"879",)&IF(A1=34,"918",)&IF(A1=35,"956",)&IF(A1=36,"995",)&IF(A1=37,"1039",)&IF(A1=38,"1083",)&IF(A1=39,"1127",)&IF(A1=40,"1171",)