必须按照顺序写
=IF(D1>120,"",IF(D1>90,"轻度",IF(D1>60,"中度",IF(D1>30,"重度","极重度"))))
=IF(D1<30,"极重度",IF(D1<60,"重度",IF(D1<90,"中度",IF(D1<120,"轻度",""))))
=IF(E2="优秀",IF(B2>10000000, B2*0.2, IF(B2>1000000,B2*0.1,1000))+30, IF(B2>10000000, B2*0.2, IF(B2>1000000,B2*0.1,1000)))
# IF的嵌套放在 外部IF的true 和 false中
判断
糖尿病患者,应为随机血糖>11.1mmol/L,或空腹血糖≥7.1mmol/L,或OGTT2小时血糖≥11.1mmol/L
在条件格式里新建规则:
若A2符合
=IF($A2=IF(AND($B2>11.1,$C2>7.1,$D2>11.1),1,0),1,0)=0
标记为红色。
note:不要绝对引用 行($的位置)