Combine two formulas in one cell

  • Thread starter Thread starter T.R.
  • Start date Start date
T

T.R.

I have a spreadsheet with formulas that calculates
percentages and rankings. My boss wants to combine two
formulas into one. He wants to see the percentage and the
rank of that cell on the same line. Is there a way to
combine two different formulas into one?

Thanks for the help.

T.R.
 
You might get a better answer if you post the current formulas, but this may get
you started:

="The Percentage is: " & text(yourpctformula,"0.00%) &
" Rank is: " & yourrankformula

You can use the =text() function to format the number the way you like.
 

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

Percent and Rank formula in one cell 1
Combining Text From Cells 3
RANKING alters when data is filtered 4
Combining a whole number and a % in one cell 1
Combining Formula's 5
Ranking Top 5 in score and percentage 1
Joining Two formulas with the Help of AND / OR / IF Functions to getthe desired result 1
TRYING TO COMBINE FORMULAS INTO AN "OR" FORMULA 3

Back
Top