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

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

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