Multiple function queries in same cell

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.
 
S

Shane Devenshire

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.
 
D

Donna

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VLOOKUP Function returning multiple values in a separate table 8
Create a Comment in a cell via a Worksheet function (not using macros)? 5
Same cell name in multiple worksheets 5
Number & Text in same cell 5
function in a cell 3
Enter data and display function result in same cell 1
returning multiple values at the same time in a function 16
How to Enter data and Function in same cell 3

Top