From: Donna on
Sorry if this is a double post. I don't see my first one.
Need help with the if function. If cell K84 says Peds, I need N84 to say
Peds. If cell K84 says Psy, I need N84 to say Psy. If K84 has any other
description, I need N84 to say Other. How do I write this? Thanks for your
help.

--
Donna
From: RagDyer on
Try this:

=IF(K84="","",IF(OR(K84={"peds","psy"}),K84,"Other"))
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Donna" <Donna(a)discussions.microsoft.com> wrote in message
news:595A5AE4-7C4E-424D-AE0F-FA28D5FD1370(a)microsoft.com...
> Sorry if this is a double post. I don't see my first one.
> Need help with the if function. If cell K84 says Peds, I need N84 to say
> Peds. If cell K84 says Psy, I need N84 to say Psy. If K84 has any other
> description, I need N84 to say Other. How do I write this? Thanks for
> your
> help.
>
> --
> Donna