比如一个单元格A10,在A10内随机输入一个数,当10=<A10<20时,在B10单元格返回1,当20=<A10<30,在B10单元格返回2,当30=<A10<40,在B10单元格返回3,40=<A10<50,在B10单元格返回4,就这样类推,用哪个函数,数组简单点吗?怎么填写?请高手解答
条件少于7个推荐使用IF(IF())
如图
IF(A1=1,"A",IF(A1=2,"B",IF(A1=3,"C",IF(A1=4,"D",""))))
条件大于7个推荐使用LOOKUP
如图=LOOKUP(A1,{1,2,3,4,5,6,7,8,9},{"A","B","C","D","E","F","G","H","I","J","k"})