Simplification help

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

"Mike Smith NC" <MikeSmithNC@discussions.microsoft.com> wrote in message
news:E4055926-576C-4AAA-8524-4CDE36D4742E@microsoft.com...
> 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"))

Thanks a bunch


"Bob Phillips" wrote:

>
>
> "Mike Smith NC" <MikeSmithNC@discussions.microsoft.com> wrote in message
> news:E4055926-576C-4AAA-8524-4CDE36D4742E@microsoft.com...
> > 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"))
>
>
>

Not a huge simplification, but hopefully it helped.

--
HTH

Bob Phillips

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

"Mike Smith NC" <MikeSmithNC@discussions.microsoft.com> wrote in message
news:32D4B4A5-A99E-465F-9F89-90357EFF267F@microsoft.com...
> Thanks a bunch
>
>
> "Bob Phillips" wrote:
>
> >
> >
> > "Mike Smith NC" <MikeSmithNC@discussions.microsoft.com> wrote in message
> > news:E4055926-576C-4AAA-8524-4CDE36D4742E@microsoft.com...
> > > 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"))
> >
> >
> >