excel公式出现false答:=IF(K14>=1,"A",IF(AND(0.9<=K14,K14<1),"B",IF(AND(0.8<=K14,K14<0.9),"C",IF(AND(0.7<=K14,K14<0.8),"D",IF(AND(0.6<=K14,K14<0.7),"E","小于0.6")))
EXCEL中同样的IF函数不同行有的显示正确有的显示FALSE?答:公式可简化如下:=IF(I168=0,"结案",IF(O168<30,"催缴",IF(O168<90,"发催款函",IF(O168<180,"发律师函","起诉")))或 =IF(O168>=180,"起诉",IF(O168>=90,"发律师函",IF(O168>=30,"发催款函",IF(O138=0,"结案","催缴")))O168>0<30,EXCEL是从左到右进行运算的 如果...