K3
=IF(H3>$H$1,"高",IF(H3=$H$1,"平","低"))
右拉至M3
N4输入公式
=IF(AND(H3=H$1,I3=I$1,J3=J$1),"满足条件","")
一起下拉即可
给了以下一组数据,利用EXCEL函数求解
K3
=IF(H3>$H$1,"高",IF(H3=$H$1,"平","低"))
右拉至M3
N4输入公式
=IF(AND(H3=H$1,I3=I$1,J3=J$1),"满足条件","")
一起下拉即可