| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
allow multiple formulas in one cell
I am trying to sum two values that are defined in other cells as
"=SUM(N2,O2)" then within the same sell i would also like to rank those results. Can this be done? Here are examples of the forumlas i would like to use in one cell if it can be done. "=SUM(N2,O2)" "=RANK($H6,$H$6:$H$25,0)" |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
allow multiple formulas in one cell
Hi,
Like this. I put a couple of spaces between the reuslts of the 2 formula =N2+O2&" "&RANK($H6,$H$6:$H$25,0) Mike "Frustrated" wrote: I am trying to sum two values that are defined in other cells as "=SUM(N2,O2)" then within the same sell i would also like to rank those results. Can this be done? Here are examples of the forumlas i would like to use in one cell if it can be done. "=SUM(N2,O2)" "=RANK($H6,$H$6:$H$25,0)" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple formats in a single cell with multiple formulas | Excel Worksheet Functions | |||
| Please help! I need multiple formulas for one cell! | Excel Discussion (Misc queries) | |||
| Help! I need multiple formulas for one cell. | Excel Worksheet Functions | |||
| Multiple Formulas in same cell | Excel Worksheet Functions | |||
| multiple formulas in one cell | Excel Worksheet Functions | |||
Hybrid Mode
