IF函数:条件判断大于某数,小于某数,并返回对应单元格值答:公式:=IF(A2>11,B2,IF(A2<11,B2,""))公式:=IF(A2=11,B2,"")当A2>11,返回B2单元格数值 当A2<11,返回B2单元格数值,不符合条件,则返回""空 当A2=11,返回B2单元格数值
wps 返回满足条件对应的单元格数值?答:B1单元格写入公式 =IF(A1="","",LOOKUP(A1,{0.001,10,16,25,30,40,60}-0.001,{1.2,1.5,1.7,2,2.2,2.5,""}))或 =IF(OR(A1>60,A1=""),"",IF(A1>40,2.5,IF(A1>30,2.2,IF(A1>25,2,IF(A1>16,1.7,IF(A1>10,1.5,1.2)))...