第1个回答 2017-03-16
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d058ccbf6c81800af51e0af2b83533fa838b4757?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
C2=IF(A2<4,IF(B2=0,0,B2),IF(A2<6,IF(B2=0,0,1),IF(B2<2,0,1)))下拉
追问当A大于6,B不管取什么值,C应=0。
追答C2=IF(A2<4,IF(B2=0,0,B2),IF(A2<6,IF(B2=0,0,1),0))下拉
第2个回答 2017-03-16
公式=IF(A1>=6,IFERROR(LOOKUP(1,0/(B1={0,1,2}),{0,0,0}),""),IF(A1>=4,IFERROR(LOOKUP(1,0/(B1={0,1,2}),{0,1,1}),""),IFERROR(LOOKUP(1,0/(B1={0,1,2}),{0,1,2}),"")))
第3个回答 2017-03-16
你试试看公式:
=IF(A1>=6,0,IF(AND(A1>=4,B1=0),0,IF(AND(A1>=4,B1>1),1,IF(AND(A1<=3,B1=0),0,IF(AND(A1<=3,B1=1),1,IF(AND(A1<=3,B1=2),2,0))))))
能适合你不 ?
顺便吐槽下,在你们有点坑,工作态度差点,无论是否请假,都要被扣到底,惨。本回答被提问者和网友采纳