E列公式: =if(and(A1>=28,B1<=0,C1<15,D1<=0),150,0)
在E1健入:IF(AND(A1>=28,B1<=0,C1<15,D1<0),150,0)
E1=IF(AND(A1>=28,B1<=0,C1<15,D1<=0),150,0)