| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
| copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Hybrid Mode
