Re: Formula error...
From: Jambruins (Jambruins_at_discussions.microsoft.com)
Date: 02/24/05
- Next message: Audrey: "RE: Adding two text cells together"
- Previous message: Dave Peterson: "Re: Finding merged cells"
- In reply to: Peo Sjoblom: "Re: Formula error..."
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 24 Feb 2005 13:57:02 -0800
that did work. Now I want the same thing but with an or function added to
the formula. Here is what my actual formula is but it doesn't work, it gives
me NL even if cell B2 is BOS or TOR or any of them:
=IF(OR(B2="BAL",B2="BOS",B2="NYY",B2="TB",B2="TOR",B2="CWS",B2="CLE",B2="DET",B2="KC",B2="MIN",B2="LAA",B2="OAK",B2="SEA",B2="TEX"),"AL","NL")
How should I enter this formula to have it work?
Thanks
"Peo Sjoblom" wrote:
> You might have a space in your formula, if this work you definitely have a
> space or something else
> not visible
>
> =IF(ISNUMBER(FIND("KC",B2)),"AL","NL")
>
>
> --
>
> Regards,
>
> Peo Sjoblom
>
>
> "Jambruins" <Jambruins@discussions.microsoft.com> wrote in message
> news:DC579DDB-7F49-476C-95FA-D0432DA97B4F@microsoft.com...
> > Cell B2 has a formula setup in it so it enters the team that is in a
> > different tab into it. I am trying to setup an if formula in cell A2 that
> > either puts an AL if true or NL if false. For example,
> >
> > Cell B2 says KC (which is from a formula setup to equal a cell in another
> > tab).
> > I type in cell A2 the following:
> > =if(B2="KC","AL","NL") and it gives me NL. If I override the formula in
> > cell B2 and just type in KC it works right and gives me AL. Any idea why
> it
> > doesn't work when the formula produces KC? Thank you.
>
>
>
- Next message: Audrey: "RE: Adding two text cells together"
- Previous message: Dave Peterson: "Re: Finding merged cells"
- In reply to: Peo Sjoblom: "Re: Formula error..."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
