Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple function queries in same cell
Hello.
Is it possible to have two functions in the same cell, even if one is already nested? Example: Function for K8: =IF(G8="PSY","PSY",IF(G8="CONTINUITY","CONTINUITY" ,IF(G8="REQUEST","PT/FAMILY REQUEST",IF(G8="AMI","CARDIAC",IF(G8="MULTI TRAUMA","TRAUMA",IF(G8="GSW","TRAUMA",IF(G8="SAH", "NEURO",""))))))) Cell C8 lists ages. Is it possible to do another function in K8 resulting in PEDS if C8 <=18? Many thanks. -- Donna |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple function queries in same cell
Hi,
=IF(C8<=18,"Peds","")&IF(G8="PSY","PSY",IF(G8="CON TINUITY","CONTINUITY",IF(G8="REQUEST","PT/FAMILY REQUEST",IF(G8="AMI","CARDIAC",IF(G8="MULTI TRAUMA","TRAUMA",IF(G8="GSW","TRAUMA",IF(G8="SAH", "NEURO",""))))))) You are trying to beat the 7 level nesting limit in 2003? Above will do it. Or get 2007, or use VLOOKUP. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Donna" wrote: Hello. Is it possible to have two functions in the same cell, even if one is already nested? Example: Function for K8: =IF(G8="PSY","PSY",IF(G8="CONTINUITY","CONTINUITY" ,IF(G8="REQUEST","PT/FAMILY REQUEST",IF(G8="AMI","CARDIAC",IF(G8="MULTI TRAUMA","TRAUMA",IF(G8="GSW","TRAUMA",IF(G8="SAH", "NEURO",""))))))) Cell C8 lists ages. Is it possible to do another function in K8 resulting in PEDS if C8 <=18? Many thanks. -- Donna |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple function queries in same cell
Thanks. How would I write it if I wanted C8 to result in Peds if the ages
were 1 - 18? Just using <=18 makes my worksheet look "busy". Thanks again. -- Donna "Shane Devenshire" wrote: Hi, =IF(C8<=18,"Peds","")&IF(G8="PSY","PSY",IF(G8="CON TINUITY","CONTINUITY",IF(G8="REQUEST","PT/FAMILY REQUEST",IF(G8="AMI","CARDIAC",IF(G8="MULTI TRAUMA","TRAUMA",IF(G8="GSW","TRAUMA",IF(G8="SAH", "NEURO",""))))))) You are trying to beat the 7 level nesting limit in 2003? Above will do it. Or get 2007, or use VLOOKUP. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Donna" wrote: Hello. Is it possible to have two functions in the same cell, even if one is already nested? Example: Function for K8: =IF(G8="PSY","PSY",IF(G8="CONTINUITY","CONTINUITY" ,IF(G8="REQUEST","PT/FAMILY REQUEST",IF(G8="AMI","CARDIAC",IF(G8="MULTI TRAUMA","TRAUMA",IF(G8="GSW","TRAUMA",IF(G8="SAH", "NEURO",""))))))) Cell C8 lists ages. Is it possible to do another function in K8 resulting in PEDS if C8 <=18? Many thanks. -- Donna |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple queries under same connection | Excel Discussion (Misc queries) | |||
Refreashing queries in multiple spreasheets | Excel Discussion (Misc queries) | |||
Importing multiple XML queries into Excel | Excel Discussion (Misc queries) | |||
Executing multiple queries through a macro | Excel Discussion (Misc queries) | |||
Multiple worksheet queries | Excel Worksheet Functions |