View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default 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!