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