View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Neia Neia is offline
external usenet poster
 
Posts: 6
Default formula x % format

I have the following numbers
412
493
1093
Totais 1998

And I need the percent, so I used 412/1998, 493/1998 ....
I found the following values 0,206206206, 0,246746747,0,547047047.
I´d like to format with % and zero decimals.

When I use this format I have a problem: the percent values do not sum
correctly.
21%, 25%, 55% and it sums 101%.

What can I do?