9宫格

=IF(AND(B2>=7,C2>=7),9,IF(AND(B2>=7,C2<7,C2>=5),7,IF(AND(B2>=7,C2<5),4,IF(AND(B2<7,B2>=5,C2>=7),8,IF(AND(B2<7,B2>=5,C2<7,C2>=5),5,IF(AND(B2<7,B2>=5,C2<5),2,IF(AND(B2<5,C2>=7),6,IF(AND(B2<5,C2<7,C2>=5),3,IF(AND(B2<5,C2<5),1,0)))))))))

上一篇:关系型数据库之双目运算--除运算


下一篇:B2 - Wonderful Coloring - 2