excel中,两个数值,其中任何一个满足条件时,怎么判定答:公式:=IF(OR(A1>=3,B1>=3),"OK",IF(OR(A1>=1.5,B1>=1.5),"NO",""))或者:=IF((A1>=3)+(B1>=3),"OK",IF((A1>=1.5)+(B1>=1.5),"NO",""))
excel中满足多个条件中的一个条件并返回值答:=IF(OR(A1=100,A1=200,A1=300,A1=400),5,IF(OR(A1=500,A1=600,A1=700,A1=800),6,""))
在EXCEL中如何设置3个条件满足满足任意一条件后决定一个单元值的函数...答:=if(or(a1=1,a1=2,a1=3),100,"")A1是条件所在单元格 1,2,3是你的三个条件,100是你满足条件后的值,具体根据情况自己修改 =if(or(and(o2>0,o2<1),and(o2>9,o2<10),and(o2>19,o2<20)),"重新计算","")
EXCEL 两个单元格中有一个满足条件就单独标记答:=IF(OR(DATEDIF(H36,DATE("2014","01","01"),"d")<0,DATEDIF(I36,DATE("2014","01","01"),"d")<0),"","1")