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)))))))))

【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/yym/p/15110884.html