Need help with if function
in [Functions]
|
From: Donna on 17 May 2010 13:04 Hello all. 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: Don Guillett on 17 May 2010 13:17 if(or(k84="peds",k84="psy"),k84,"other") -- Don Guillett Microsoft MVP Excel SalesAid Software dguillett(a)gmail.com "Donna" <Donna(a)discussions.microsoft.com> wrote in message news:00F9E62C-E04D-402E-9FE6-246CEB8AB1D8(a)microsoft.com... > Hello all. 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: Luke M on 17 May 2010 13:18 In cell N84: =IF(OR(K84="Peds",K84="Psy"),K84,"Other") -- Best Regards, Luke M "Donna" <Donna(a)discussions.microsoft.com> wrote in message news:00F9E62C-E04D-402E-9FE6-246CEB8AB1D8(a)microsoft.com... > Hello all. 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
|
Pages: 1 Prev: Convert a text in a date format Next: How do I calculate the 3 sigma of a number? |