更新时间2018-05-25 13:58:42
号码1-10,按大小和单双属性分 比较简单。 现在要对一列号码做属性判断 ,分为大单(7,9)、大双(6,8,10)、小单(1,3,5)和小双(2,4)。
如何用函数if和or确定号码属性呢?
=IF(OR(A1=1,A1=3,A1=5),"小单",IF(OR(A1=2,A1=4),"小双",IF(OR(A1=7,A1=9),"大单",IF(OR(A1=6,A1=8,A1=10),"大双",""))))
————————————————————
=LOOKUP(A1,{1,2,3,4,5,6,7,8,9,10},{"小单","小双","小单","小双","小单","大双","大单","大双","大单","大双"})
上一篇:大红袍的壶泡什么茶好啊?
下一篇:为什么体彩的走势图不同步?