excel中if多层嵌套怎么解决?答:或者输入 =IF(B2<9,2,IF(B2<16,3,IF(B2<26,5,IF(B2<51,8,IF(B2<91,13,IF(B2<151,20,IF(B2<281,32,IF(B2<501,50,IF(B1<1201,80,IF(B2<3201,125,IF(B2<10001,200,IF(B2<35001,315,IF(B2<150001,500,800)))
if函数多层嵌套应该怎样操作?答:=if(true,1,if(true,2,if(true,3,"end")))大概就是这么一个意思了。第二个IF是第一个IF的逻辑值为FALSE时的返回值,第三个IF又是第二个IF的逻辑值为FALSE时的返回值。在OFFICE2003中,IF只能套七层。至于用处,可以用来判断多个条件啊。=if(成绩>90,"优",if(成绩>80,"良",if(成绩>...