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!
|