Multiple function queries in same cell

  • Thread starter Thread starter Donna
  • Start date Start date
D

Donna

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.
 
Hi,

=IF(C8<=18,"Peds","")&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","")))))))

You are trying to beat the 7 level nesting limit in 2003? Above will do it.
Or get 2007, or use VLOOKUP.
 
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.
 
Back
Top