Re: IF & OR Functions

The part you wrote worked great. This is the whole IF function

=IF(OR('A-V Input'!A5={"HS-U","HS-D","HS-R","HS-L"}),"U-MHU-MCS",IF('A-V
Input'!A5="H","U-MHU",IF('A-V Input'!A5="ST-C","U-MCS-W",IF('A-V
Input'!A5="ST","U-MCS",IF('A-V Input'!A5="HS-C","U-MHU-MCS","-")))))

It works the way I wanted. If you can shorten it up feel free I am open to
suggestions

Thanks alot



"RagDyer" wrote:

> What's supposed to happen when there is no match?
>
> Anyway, try this:
>
> =IF(OR(A1={"HS-U","HS-D","HS-R","HS-L"}),"U-HS-MCS","No Match")
> --
> HTH,
>
> RD
> ==============================================
> Please keep all correspondence within the Group, so all may benefit!
> ==============================================
>
>
>
> "Lee" <Lee@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:31D4A8D3-7B30-44C6-9D1C-A14EFC6471AB@xxxxxxxxxxxxxxxx
> > Can you use a OR function in an IF function.
> >
> > I'm trying to check a cell on *** 1 for certain text such as
> > "HS-C"
> > "HS-U"
> > "HS-D"
> > "HS-R"
> > "HS-L"
> > "HS"
> > "ST-C"
> > "ST"
> >
> > if the cell has "HS-L" or "HS-U" or"HS-D" or"HS-R" the IF function would
> > return "U-HS-MCS, I could probally nest the others in the False setion of
> the
> > IF function. I just need to know how to group them together, without
> having a
> > long nested IF function,
> >
> > By the way is there a limit to have many nested IF functions are allowed?
>
>
.

Quantcast