在excel中if函数如何实现多重判断?答:公式: =IF((A3=A2)*(AW3=AW2),"是","否") 或者: =IF(AND(A3=A2,AW3=AW2),"是","否") 以上是按题目要求同时满足两个条件的,如果想只满足其中一个就显示是,公式: =IF((A3=A2)+(AW3=AW2),"是","否") 或者: =IF(OR(A3=A2,AW3=AW2),"是","否")请问...
excel中多重判断条件的IF语句的输入答:excel中多重判断条件的IF语句的语法是:=IF(条件,真值,IF(条件,真值,假值))题主的正确语句应该是:=IF(0<=(D7-B7)<=5,B7,IF(6<=(D7-B7)<=10,B7*1.25,IF(10<=(D7-B7),B7*1.5,IF(-5<=(D7-B7)<=-1,B7*0.75,IF(-10<=(D7-B7)<=-5,B7*0.5,0)))题主的语句...