excel表格 A1小于20则A1乘以0.15,A1大于20小于50则A1乘以0.2,A1大于50...答:使用下列公式之一 =A1*IF(A1<20,0.15,IF(A1<50,0.2,0.3))=A1*IF(A1<20,0.15,IF(A1>=50,0.3,0.2))=A1*IF(A1>=50,0.3,IF(A1<20,0.15,0.2))=A1*IF(A1>=50,0.3,IF(A1>=20,0.2,0.15))=A1*IF(A1<50,IF(A1<20,0.15,0.2),0.3)=A1*IF(A1<50,IF(A1...
excel一个单元格中求值,当a大于b则等于c,当a小于b,则等于c,当a等于b...答:=if(a>b,c,if(a<b,c,c/2)),嵌套一下就好,或者用不等号,=if(a<>b,c,c/2)