Need help with if function
in [Functions]
|
Prev: How do I calculate the 3 sigma of a number?
Next: count number of columns based on values across a row
From: Donna on 17 May 2010 13:22 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 17 May 2010 14:51
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 |