Excel表格中If函数多个条件计算？

Question

当15≤X≤20时，结果=X
当X＞20时，结果=1.02*X
当X＜15时，结果=0.98*X

Answer 1

建议参照如下:

在J4单元格中输入公式：

=IF(I4<1000,"小微",IF(AND(I4>=1000,I4<5000),"三级",IF(AND(I4>=5000,I4<10000),"二级",IF(AND(I4>=10000,I4<50000),"一级","特级"))))

如图：

Answer 2

=if(a1>20,a1*1.02,if(a1>=15,a1,a1*0.98))
或者=if(a1<15,a1*0.98,if(a1<=20,a1,a1*1.02))

Answer 3

=IF(A2>20,1.02*A2,IF(A2<15,0.98*A2,A2))

Answer 4

=IF(A1>20,1.02,IF(A1<15,0.98,1))*A1

Answer 5

公式为：
=IF(A1>20,1.02,IF(A1<15,0.98,1)) * A1