View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
NSNR[_2_] NSNR[_2_] is offline
external usenet poster
 
Posts: 5
Default formula x % format

Hi,
This is what I get and total is 100%
412 21%
493 25%
1093 55%
1998 100%
formula is: =A1/1998
You need to cpy the formula for total row as well, don't manually add
percentage because they are rounded (you don't want decimal)

"Neia" wrote:

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?