【紧急】求助大神!!!复杂的EXCEL表格公式答:E1输入:=IF(AND(A1=B1:C1),"豹子",IF(OR(A1=B1:C1,C1=A1:B1),"对子",IF(COUNT(FIND(SUM(SMALL(A1:C1,{1,2,3})*10^{0,1,2}),9876543210980910)),"顺子",IF(COUNT(FIND(A1:C1&TRANSPOSE(A1:C1),98765432109)),"半顺","杂六")))ctrl+shift+回车下拉 ...
excel求大神帮忙答:参考结果公式:=3000+SUMPRODUCT(IF(A1-{400,500,600,800,900}>0,A1-{400,500,600,800,900},)*{4,0.5,0.5,0.5,5})