公式太长，求高手简化

我是制作工资表的。因为产品规格不一样，工资的单价也不同。所以在引用单价时公式太长的有没有办法简化一下

=IF(AND(B4<=89,C4<=499,D4<=3),工资标准!$B$3,IF(AND(B4<=89,C4>=500,C4<=999, D4<=3),工资标准!$B$3*1.5,IF(AND(B4<=89,C4>=1000,C4<=1499, D4<=3),工资标准!$B$3*2,IF(AND(B4<=89,C4>=1500,C4<=2000, D4<=3),工资标准!$B$3*2.5,IF(AND(B4<=89,C4<=499,D4>3),工资标准!$B$3*1.2,IF(AND(B4<=89,C4>=500,C4<=999, D4>3),工资标准!$B$3*1.5*1.2,IF(AND(B4<=89,C4>=1000,C4<=1499, D4>3),工资标准!$B$3*2*1.2,IF(AND(B4<=89,C4>=1500,C4<=2000, D4>3),工资标准!$B$3*2.5*1.2,IF(AND(B4>89,B4<=108,C4<=499,D4<=3),工资标准!$B$3*1.2,IF(AND(B4>89,B4<=108,C4>=500,C4<=999, D4<=3),工资标准!$B$3*1.8,IF(AND(B4>89,B4<=108,C4>=1000,C4<=1499, D4<=3),工资标准!$B$3*2.4,IF(AND(B4>89,B4<=108,C4>=1500,C4<=2000, D4<=3),工资标准!$B$3*3,IF(AND(B4>89,B4<=108,C4<=499,D4>3),工资标准!$B$3*1.2*1.2,IF(AND(B4>89,B4<=108,C4>=500,C4<=999, D4>3),工资标准!$B$3*1.8*1.2,IF(AND(B4>89,B4<=108,C4>=1000,C4<=1499, D4>3),工资标准!$B$3*2.4*1.2,IF(AND(B4>89,B4<=108,C4>=1500,C4<=2000, D4>3),工资标准!$B$3*3*1.2,IF(AND(B4>108,B4<=114,C4<=499,D4<=3),工资标准!$B$3*1.5,IF(AND(B4>108,B4<=114,C4>=500,C4<=999, D4<=3),工资标准!$B$3*2.3,IF(AND(B4>108,B4<=114,C4>=1000,C4<=1499, D4<=3),工资标准!$B$3*3,IF(AND(B4>108,B4<=114,C4>=1500,C4<=2000, D4<=3),工资标准!$B$3*3.8,IF(AND(B4>108,B4<=114,C4<=499,D4>3),工资标准!$B$3*1.5*1.2,IF(AND(B4>108,B4<=114,C4>=500,C4<=999, D4>3),工资标准!$B$3*2.3*1.2,IF(AND(B4>108,B4<=114,C4>=1000,C4<=1499, D4>3),工资标准!$B$3*3*1.2,IF(AND(B4>108,B4<=114,C4>=1500,C4<=2000, D4>3),工资标准!$B$3*3.8*1.2,IF(AND(B4>114,B4<=133,C4<=499,D4<=3),工资标准!$B$3*1.8,IF(AND(B4>114,B4<=133,C4>=500,C4<=999, D4<=3),工资标准!$B$3*2.7,IF(AND(B4>114,B4<=133,C4>=1000,C4<=1499, D4<=3),工资标准!$B$3*3.6,IF(AND(B4>114,B4<=133,C4>=1500,C4<=2000, D4<=3),工资标准!$B$3*4.5,IF(AND(B4>114,B4<=133,C4<=499,D4>3),工资标准!$B$3*1.8*1.2,IF(AND(B4>114,B4<=133,C4>=500,C4<=999, D4>3),工资标准!$B$3*2.7*1.2,IF(AND(B4>114,B4<=133,C4>=1000,C4<=1499, D4>3),工资标准!$B$3*3.6*1.2,IF(AND(B4>114,B4<=133,C4>=1500,C4<=2000, D4>3),工资标准!$B$3*4.5*1.2,IF(AND(B4>133,C4<=499,D4<=3),工资标准!$B$3*2.2,IF(AND(B4>133,C4>=500,C4<=999, D4<=3),工资标准!$B$3*3.3,IF(AND(B4>133,C4>=1000,C4<=1499, D4<=3),工资标准!$B$3*4.4,IF(AND(B4>133,C4>=1500,C4<=2000, D4<=3),工资标准!$B$3*5.5,IF(AND(B4>133,C4<=499,D4>3),工资标准!$B$3*2.2*1.2,IF(AND(B4>133,C4>=500,C4<=999, D4>3),工资标准!$B$3*3.3*1.2,IF(AND(B4>133,C4>=1000,C4<=1499, D4>3),工资标准!$B$3*4.4*1.2,IF(AND(B4>133,C4>=1500,C4<=2000, D4>3),工资标准!$B$3*5.5*1.2))))))))))))))))))))))

就是当产品规格满足要求时，即直径、长、厚、轴长这四个条件同时满足一定范围时，自动取相应的范围的单价。比如89*450*2.0*500,即取单价为0.15.如果89*500*2.0*500,即取单价为0.15*1.2