View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Luke M[_4_] Luke M[_4_] is offline
external usenet poster
 
Posts: 457
Default Need help with if function

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

--
Best Regards,

Luke M
"Donna" wrote in message
...
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