1. 把你的criteria table 改成以下的layout




2. E2 的Cell 放入以下formula,然后往下copy paste

  
    =IF(AND(B2="Male",C2>=G$4,C2<=H$4,D2>=I$4,D2<=J$4),"Normal",
    IF(AND(B2="Male",C2>=G$5,C2<=H$5,D2>=I$5,D2<=J$5),"Normal",
    IF(AND(B2="Male",C2>=G$6,C2<=H$6,D2>=I$6,D2<=J$6),"Normal",
    IF(AND(B2="Female",C2>=G$4,C2<=H$4,D2>=K$4,D2<=L$4),"Normal",
    IF(AND(B2="Female",C2>=G$5,C2<=H$5,D2>=K$5,D2<=L$5),"Normal",
    IF(AND(B2="Female",C2>=G$6,C2<=H$6,D2>=K$6,D2<=L$6),"Normal",
    "Not Normal"))))))
  




3. 然后就可以了, 记得double check E2 的formula

Source: ---

---

Disclaimer: The information in this webpage is shared by anonymous users from external online sources. We cannot guarantee its accuracy or truthfulness. Users should exercise caution and verify information independently.

---