Combining 2 percentages into one cell and displaying as % format

R

RLind

I have once cell that is 75% and one cell that is 25%.

I would like to combine the two into one cell that looks like this "75% / 25%"

Concatenate does not seem to work for me since these are not text so it does
not display as %s.

Thanks for your help!
 
S

Shane Devenshire

Sorry should have also said, if you want spaces before and after the /

=100*C7&"% / "&100*B7&"%"
 

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

Excel does not accept text format! 0
How do I count the number of entries of specifc criteria is met 2
*Issue* Concatenate dates in a large range of cells in a row. 5
Combining three files when middle file has sections with endnotes 2
Payment calculation 1
If statement based on time ranges 2
Possible to Combine reports to's to a single box? 0
shading a cell or group of cells based on value 5

Top