Simplification help
Thanks a bunch
"Bob Phillips" wrote:
"Mike Smith NC" wrote in message
...
these formulas works fine but is there a simpler way to write them:
1.
IF(OR(Model!E6="L",Model!E6="B"),IF(OR(Model!L3=K7 ,Model!L3=K8
,Model!L3=K9,Model!L3=K10,Model!L3=K11,Model!L3=K1 2,Model!L3=K13
,Model!L3=K14,Model!L3=K15,Model!L3=K16,Model!L3=K 17,Model!L3=K18
,Model!L3=K19,Model!L3=K20),"0.15
PSIG",IF(OR(Model!C8="W",Model!C8="T"),"2
PSIG",IF(OR(Model!C8="M",Model!C8="R"),"0.65 PSIG"))),N18)
=IF(OR(Model!E6={"L","B"}),
IF(ISNUMBER(MATCH(Model!L3,K7:K20,0)),"0.15 PSIG",
IF(OR(Model!C8={"W","T"}),"2 PSIG",
IF(OR(Model!C8={"M","R"}),"0.65 PSIG"))),N18)
2.
=IF(Model!A2=70,"",IF(Model!E6="L",IF(Model!C8="M" ,IF(OR(Model!N5=L12
,Model!N5=L13,Model!N5=L14,Model!N5=L15,Model!N5=L 16,Model!N5=L17
,Model!N5=L18,Model!N5=L19),"0.15 PSIG","0.29
PSIG")),IF(Model!E6="H",IF(Model!C8="W","100
PSIG",IF(OR(Model!C8="T",Model!C8="M"),"85 PSIG")))))
=IF(Model!A2=70,"",IF(Model!E6="L",IF(Model!C8="M" ,
IF(ISNUMBER(MATCH(Model!N5,L12:L19,0)),"0.15 PSIG","0.29
PSIG")),IF(Model!E6="H",IF(Model!C8="W","100
PSIG",IF(OR(Model!C8={"T","M"}),"85 PSIG")))))
3.
=IF(A2=250,"",IF(C8="R","",IF(C8="H","",IF(E6="H", ""
,IF(OR(AND(C8="W",E6="L",F6=-2),AND(C8="W",E6="B",F6=-2)
,AND(C8="T",E6="L",F6=-2),AND(C8="M",E6="L",F6=-2)),"","-WX")))))
=IF(OR(A2=250,C8="R",C8="H",E6="H"),"",
IF(OR(AND(OR(C8={"W","T","M"}),E6="L",F6=-2),AND(C8="W",E6="B",F6=-2)),"","-
WX"))
|