View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Donna Donna is offline
external usenet poster
 
Posts: 180
Default 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