EXCEL表A1小于10时,B1等于5,A1大于10且小于20时,B1等于10,A1大于20时等于15,怎么设置，求帮助

Question

如题所述

Answer 1

B1单元格输入公式
=IF(A1<10,5,IF(A1<20,10,15))

Answer 2

=IF(ISNUMBER(A1),LOOKUP(A1,{-9E-307,11,21,9E+307},{5,10,15}),"非数值")

Answer 3

=IF(A1<10,5,(IF(AND(A1>10,A1<20),10,(IF(AND(A1>20),15,"")))))

Answer 4

B1=vlookup(A1,{0,5;10,10;20,15},2)

Answer 5

B1=IF(A1<10,5,IF(AND(A1>10,A1<20),10,IF(A1>20,15)))本回答被提问者采纳