求EXCEL里条件公式,请高手指点,谢谢!

2025-04-14 18:09:30
推荐回答(3个)
回答1:

E列公式: =if(and(A1>=28,B1<=0,C1<15,D1<=0),150,0)

回答2:

在E1健入:IF(AND(A1>=28,B1<=0,C1<15,D1<0),150,0)

回答3:

E1
=IF(AND(A1>=28,B1<=0,C1<15,D1<=0),150,0)