Re: IF & OR Functions

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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 sheet 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?
>
>
.

Relevant Pages

  • Re: copy formulas by dragging vertically
    ... This will link F1 on Sheet S05-06, ... To any cell that you enter it into, ... > With formulas like that autofilling won't work? ... >> Please keep all correspondence within the Group, ...
    (microsoft.public.excel.misc)
  • Re: Pasting constant formula where referral sheet changes
    ... Did the cell you entered the formula into return the contents of cell I25 on ... Please keep all correspondence within the NewsGroup, ... It did not alter the sheet referred to ... >>> I am creating a data tracking workbook. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: How to return the last non-blank cell in a column that is TEXT
    ... Please keep all correspondence within the Group, ... I tried plugging in the first one but ... If you want to simply enter a formula in any cell in Column C of Sheet2, ... Column D in sheet 1 has TEXT and no numbers. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: copy offset to cell
    ... Please keep all correspondence within the Group, ... Click on the fill handle of this *4 cell* selection, ... I want to copy the values of cells in sheet A to cells in sheet ...
    (microsoft.public.excel.misc)
  • Re: copy offset to cell
    ... Please keep all correspondence within the NewsGroup, ... "RagDyeR" wrote: ... Click on the fill handle of this *4 cell* selection, ... I want to copy the values of cells in sheet A to cells in ...
    (microsoft.public.excel.misc)