比如当C2>=200时,D2为1,大于等于400时,值为2,大于等于600时,值为3,怎么设公式啊,小弟菜鸟
æ¥éª¤å¦ä¸ï¼
1.æ ¹æ®A1åå æ ¼æ°å¼ï¼B1æ°å¼ååï¼è¾å ¥å ¬å¼å¦ä¸ï¼
2.è¿æ ·A1ååï¼B1å°±è·çååäºï¼
条件少于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"})
要超过7个吧,不过第二个不是很懂,括号里都没大小关系啊
D2输入
=LOOKUP(C2,{200,400,600;1,2,3})
或者输入=IF(C2>=600,3,IF(C2>=400,2,1))
详见附图