请求excel高手，帮我写一个判断公式

显示全部楼层 · 2013-1-7 20:08:05

=IF(A1>=6,30*(A1-5)+125,IF(AND((A14)),25*(A1-4)+100,IF(AND((A13)),30*(A1-3)+70,IF(AND((A13)),70*(A1-2),"")))) 你没说3,IF(A2>4,IF(A2>=6,(A2-5)*30+125,(A2-4)*25+100),(A2-3)*30+70),(A2-2)*70))这样不更简单吗？...

千问 · 2013-1-7 20:08:05

线索太少, 试试看吧:=IF(H41<3,"",IF(H41<4,70*(H41-2),IF(H41<5,30*(H41-3)+70,IF(H41<7,25*(H41-4)+100,30*(H41-5)+125))))...

千问 · 2013-1-7 20:08:05

=if("2<A1<=3","70*(A1-2)",lf("3<A1<=4","30*(A1-3)+70",if("4<A1<=6","25*(A1-4)+100","30*(A1-5)+125"))),可以了，记得选满意哦，不容易码...

千问 · 2013-1-7 20:08:05

=IF(H41<=2,0,IF(H41<=3,(H41-2)*70,IF(H14<=4,(H41-3)*30+70,IF(H14<6,(H41-4)*25+100,(H41-5)*30+125)))) h41根据实际改一下...