Need help with if function

[Donna]

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

 

[Don Guillett]

if(or(k84="peds",k84="psy"),k84,"other")

 

[Luke M]

In cell N84:
=IF(OR(K84="Peds",K84="Psy"),K84,"Other")