| 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 |
| 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 | |||
Threaded Mode
