Thread
:
Need help with if function
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Don Guillett[_2_]
external usenet poster
Posts: 1,522
Need help with if function
if(or(k84="peds",k84="psy"),k84,"other")
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"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
Reply With Quote
Don Guillett[_2_]
View Public Profile
Find all posts by Don Guillett[_2_]