必须按照顺序写
=IF(D1>120,"",IF(D1>90,"轻度",IF(D1>60,"中度",IF(D1>30,"重度","极重度"))))
=IF(D1<30,"极重度",IF(D1<60,"重度",IF(D1<90,"中度",IF(D1<120,"轻度",""))))
EXCEL--多条件3
原文：https://www.cnblogs.com/super-yb/p/11445816.html
