在E4单元格输入公式：="G"&IF(B4="男",IF(C4<165,"↓↓",IF(C4<170,"↓","√")),IF(C4<155,"↓↓",IF(C4<160,"↓","√")))&"N"&IF(B4="男",IF(D4<=70,"√",IF(D4<75,"↑","↑↑")),IF(D4<55,"√",IF(D4<60,"↑","↑↑")))复制并下拉即可
