Question

EXCEL多条件选择如何设置函数？

当a1>3并且a1<5时用a1*17

当a1>5并且a1<10时用a1/8
当a1>10并且a1<20时用a1*52
当a1>20并且a1<30时用a1/33
这个函数要如何设置公式

Answer 1

=IF(A1<3,"",IF(A1<5,A1*17,IF(A1<10,A1/8,IF(A1<20,A1*52,IF(A1<30,A1/33,"")))))

Answer 2

=IF(OR(A1<=3,A1>=30),"",LOOKUP(A1,{3,5,10,20},{17,1/8,52,1/33})*A1)