excel if语句嵌套超过上限 球解决方案 谢谢啦

excel小白 代码如下:
=IF(A2<=1000,"1",IF(A2<=1050,"2",IF(A2<=1100,"3",IF(A2<=1150,"4",IF(A2<=1200,"5",IF(A2<=1250,"6",IF(A2<=1300,"7",IF(A2<=1350,"8",IF(A2<=1400,"9",IF(A2<=1450,"10",IF(A2<=1500,"11",IF(A2<=1550,"12",IF(A2<=1600,"13",IF(A2<=1650,"14",IF(A2<=1700,"15",IF(A2<=1750,"16",IF(A2<=1800,"17",IF(A2<=1850,"18",IF(A2<=1900,"19",IF(A2<=1950,"20",IF(A2<=2000,"21",IF(A2<=2050,"22",IF(A2<=2100,"23",IF(A2<=2150,"24",IF(A2<=2200,"25",IF(A2<=2250,"26",IF(A2<=2300,"27",IF(A2<=2350,"28",IF(A2<=2400,"29",IF(A2<=2450,"30",IF(A2<=2500,"31",IF(A2<=2550,"32",IF(A2<=2600,"33",IF(A2<=2650,"34",IF(A2<=2700,"35",IF(A2<=2750,"36",IF(A2<=2800,"37",IF(A2<=2850,"38",IF(A2<=2900,"39",IF(A2<=2950,"40",IF(A2<=3000,"41",IF(A2<=3050,"42",IF(A2<=3100,"43",IF(A2<=3150,"44",IF(A2<=3200,"45",IF(A2<=3250,"46",IF(A2<=3300,"47",IF(A2<=3350,"48",IF(A2<=3400,"49",IF(A2<=3450,"50",IF(A2<=3500,"51",IF(A2<=3550,"52",IF(A2<=3600,"53",IF(A2<=3650,"54",IF(A2<=3700,"55",IF(A2<=3750,"56",IF(A2<=3800,"57",IF(A2<=3850,"58",IF(A2<=3900,"59",IF(A2<=3950,"60",IF(A2<=4000,"61",IF(A2<=4050,"62",IF(A2<=4100,"63",IF(A2<=4150,"64",IF(A2<=4200,"65",IF(A2<=4250,"66",IF(A2<=4300,"67",IF(A2<=4350,"68",IF(A2<=4400,"69",IF(A2<=4450,"70",IF(A2<=4500,"71",IF(A2<=4550,"72"))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))

麻烦各位解答一下

1个回答

感觉只要2个判断IF(A2<=1000,"1",Int((A2-951)/50))
Csdn user default icon
上传中...
上传图片
插入图片
抄袭、复制答案,以达到刷声望分或其他目的的行为,在CSDN问答是严格禁止的,一经发现立刻封号。是时候展现真正的技术了!