可以用这个公式：=IF(COUNT(D4:L4)>2,"高",IF(COUNT(D4:L4)>1,"中",MID("低中高",INT((M3-1)/10+1),1)))&"级别风险预警"
N4单元输入：=IF(OR(COUNT(D5:L5)=3,M4>20),"高级别风险预警",IF(OR(COUNT(D5:L5)=2,M4>10),"中级别风险预警",IF(M4>0,"低级别风险预警",,"")))下拉公式
