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
Cumulative formula for word table 0
Help Writing a SUM Formula 5
Would like to input 3 letters into a cell, each having a different numerical value 5
combining multiple columns using ", " seperations.. 4
Multiple IF Statement in Word 5
Using IF and VLOOKUP for range of cells 5
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0

Top