在H3单元格输入公式：=IF((C3>=45)*(D3>=50)*(G3>=310),"上线","")或者：=IF(COUNTIFS(C3,">=45",D3,">=50",G3,">=310"),"上线","")复制并下拉，即可。
=IF(AND(C3>=45,D3>=50,G3>=310)，“上线”，“”)
