ExcelBanter - allow multiple formulas in one cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - allow multiple formulas in one cell (https://www.excelbanter.com/excel-worksheet-functions/244983-allow-multiple-formulas-one-cell.html)

Frustrated

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)"

Mike H

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)"

All times are GMT +1. The time now is 02:20 AM.