EXCEL里if语句判断多条件给定单元格所返回的值

发布网友发布时间：2022-04-29 05:39

共4个回答

热心网友时间：2022-06-19 22:02

第一个格子里填下面:

=IF((A1=B1)*AND(B1=C1),"豹子",IF((A1=B1),"对子",IF(A1=C1,"对子",IF(B1=C1,"对子",IF((A1+1=B1)*AND(B1+1=C1),"顺子",IF((A1+1=C1)*AND(C1+1=B1),"顺子",IF((B1+1=C1)*AND(C1+1=A1),"顺子",IF((B1+1=A1)*AND(A1+1=C1),"顺子",IF((C1+1=A1)*AND(A1+1=B1),"顺子",IF((C1+1=B1)*AND(B1+1=A1),"顺子",IF(A1+1=B1,"半顺",IF(A1+1=C1,"半顺",IF(B1+1=A1,"半顺",IF(B1+1=C1,"半顺",IF(C1+1=A1,"半顺",IF(C1+1=B1,"半顺","杂六"))))))))))))))))

第二个:=IF((MOD(A1+B1+C1,10)=0)*AND(D1+E1=10),"牛牛",IF((MOD(A1+B1+C1,10)=0),"牛"&MOD(D1+E1,10),"无牛"))

还有,你给的表格里面第二条和最后两条是不是算错了

我的是

如果按照后面的描述,那么牛牛那个你可以按照我的思路,在后面继续添加IF语句,后面组合很多,慢慢写

热心网友时间：2022-06-19 22:02

热心网友时间：2022-06-19 22:03

=IF((A1=B1)*AND(B1=C1),"豹子",IF((A1=B1),"对子",IF(A1=C1,"对子",IF(B1=C1,"对子",IF((MOD(A1+1,10)=B1)*AND(MOD(B1+1,10)=C1),"顺子",IF((MOD(A1+1,10)=C1)*AND(MOD(C1+1,10)=B1),"顺子",IF((MOD(B1+1,10)=C1)*AND(MOD(C1+1,10)=A1),"顺子",IF((MOD(B1+1,10)=A1)*AND(MOD(A1+1,10)=C1),"顺子",IF((MOD(C1+1,10)=A1)*AND(MOD(A1+1,10)=B1),"顺子",IF((MOD(C1+1,10)=B1)*AND(MOD(B1+1,10)=A1),"顺子",IF(MOD(A1+1,10)=B1,"半顺",IF(MOD(A1+1,10)=C1,"半顺",IF(MOD(B1+1,10)=A1,"半顺",IF(MOD(B1+1,10)=C1,"半顺",IF(MOD(C1+1,10)=A1,"半顺",IF(MOD(C1+1,10)=B1,"半顺","杂六"))))))))))))))))
这个才是正确的公式，前面那个 029输出结果是杂六，正确的应该是半顺

热心网友时间：2022-06-19 22:03

=IF(LARGE(A2:C2,1)=SMALL(A2:C2,1),"豹子",IF(OR(LARGE(A2:C2,1)=LARGE(A2:C2,2),SMALL(A2:C2,1)=SMALL(A2:C2,2)),"对子",IF(OR(LARGE(A2:C2,1)-AVERAGE(A2:C2)=1,AND(LARGE(A2:C2,1)=9,LARGE(A2:C2,2)=1,SMALL(A2:C2,1)=0)),"顺子",IF(OR(LARGE(A2:C2,1)-LARGE(A2:C2,2)=1,SMALL(A2:C2,2)-SMALL(A2:C2,1)=1),"半顺","杂六"))))追问你的答案很好，牛牛的怎么做？

追答这个不知道