豌丶dou 2019-06-04 18:56 采纳率: 0%
浏览 272

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条回答 默认 最新

  • threenewbee 2019-06-04 19:52
    关注
    感觉只要2个判断IF(A2<=1000,"1",Int((A2-951)/50))
    
    评论

报告相同问题?

悬赏问题

  • ¥15 聚类分析或者python进行数据分析
  • ¥15 如何用visual studio code实现html页面
  • ¥15 逻辑谓词和消解原理的运用
  • ¥15 三菱伺服电机按启动按钮有使能但不动作
  • ¥15 js,页面2返回页面1时定位进入的设备
  • ¥50 导入文件到网吧的电脑并且在重启之后不会被恢复
  • ¥15 (希望可以解决问题)ma和mb文件无法正常打开,打开后是空白,但是有正常内存占用,但可以在打开Maya应用程序后打开场景ma和mb格式。
  • ¥20 ML307A在使用AT命令连接EMQX平台的MQTT时被拒绝
  • ¥20 腾讯企业邮箱邮件可以恢复么
  • ¥15 有人知道怎么将自己的迁移策略布到edgecloudsim上使用吗?