Simplification help

M

Mike Smith NC

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=K12,Model!L3=K13
,Model!L3=K14,Model!L3=K15,Model!L3=K16,Model!L3=K17,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)

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=L16,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")))))

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")))))

Thanks for any help
 
B

Bob Phillips

Mike Smith NC said:
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=K12,Model!L3=K13
,Model!L3=K14,Model!L3=K15,Model!L3=K16,Model!L3=K17,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=L16,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"))
 
M

Mike Smith NC

Thanks a bunch


Bob Phillips said:
=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)




=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")))))




=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"))
 
B

Bob Phillips

Not a huge simplification, but hopefully it helped.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top