Combining 2 percentages into one cell and displaying as % format
 

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!

Combining 2 percentages into one cell and displaying as % format
 

Hi,
I assume that your percentages are in A1 and B1 so in C1 emter

=A1&" / "&B1

"RLind" wrote:

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!

Combining 2 percentages into one cell and displaying as % format
 

OOPS, use

=A1&"%"&" / "&B1&"%"

"RLind" wrote:

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!

Combining 2 percentages into one cell and displaying as % format
 

=TEXT(A1,"0%")&" / "&TEXT(B1,"0%")


"RLind" wrote:

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!

Combining 2 percentages into one cell and displaying as % format
 

Hi,

Or

=100*A1&"%/"&100*B1&"%"

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"RLind" wrote:

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!

Combining 2 percentages into one cell and displaying as % format
 

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

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

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"RLind" wrote:

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!