=IF(LEFT($E5)="A",3200,IF(AND(LEFT($E5)="B",--MID($E5,2,2)<=5),4000,IF(AND(LEFT($E5)="B",--MID($E5,2,2)>5),5000,IF(AND(LEFT($E5)="C",--MID($E5,2,2)<=5),5000,IF(AND(LEFT($E5)="C",--MID($E5,2,2)>5),6000,IF(AND(LEFT($E5)="D",--MID($E5,2,2)<=5),6000,IF(AND(LEFT($E5)="D",--MID($E5,2,2)>5),8000,IF(AND(LEFT($E5)="E",--MID($E5,2,2)<=5),8000,IF(AND(LEFT($E5)="E",--MID($E5,2,2)>5),14000,IF(AND(LEFT($E5)="F",--MID($E5,2,2)<=5),14000,IF(AND(LEFT($E5)="F",--MID($E5,2,2)>5),18000,IF(LEFT($E5)="G",20000,0))))))))))))
我用IF套起来了 |