Need help with if function
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 |
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 |
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 |
All times are GMT +1. The time now is 01:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com