EXCEL功能中函数IF怎样用答:=if(a1="","",if(a1<=2000,0,if(a1<=2500,a1-0.05,if(a1<=4000,a1-0.1-25,if(a1<=7000,a1-0.15-125,if(a1<=22000,a1-0.2-375,if(a1<=52000,a1-0.25-1375)))假设你的个人当月收入是在A列起,且从A1就开始,那么B1里输入这个公式,一直向下拉,拉到你觉得你的数据不超过...
excel if条件怎么写答:用IF嵌套公式,需要注意多层IF函数嵌套的逻辑关系,并避免逻辑关系重复、遗漏、冗余。=IF(I3>=90,"优秀",IF(I3>=80,"良好",IF(I3>=70,"中等",IF(I3>=60,"及格","不及格")))也可以简化为 =LOOKUP(I3,{0,60,70,80,90;"不及格","及格","中等","良好","优秀"})详见附图 ...
关于Excel中的if函数答:公式=IF(A1>360,"全能生",IF(A2>=160,"理科生","文科生"))见附图 将公式中A2改为数学成绩所在的单元格+物理成绩所在的单元格,如数学成绩在A2,物理成绩在A3,则公式改为=IF(A1>360,"全能生",IF(A2+A3>=160,"理科生","文科生"))...