allow multiple formulas in one cell

F

Frustrated

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

Mike H

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
 

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

Ranking Sales Reps 2
combining multiple columns using ", " seperations.. 4
Help required in merging two formulas into one 2
IF stmt with multiple results 4
Backfilling monthly volume forecast based on annual forecast 2
Alternative to multiple IF limits 5
Indirect formulas in cells not holding cell format after copy 1
Extracting elements of a string cell 11

Top