Calculating exact percentages in excel [Solved/Closed]

- - Latest reply: rizvisa1
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
- Jun 8, 2010 at 03:51 PM
Hello,

I'm trying to add exact percentages like 99.54%, 84.23% in six cells then calculate the average. I've tried =AVERAGE(A1:B1:C1) but it only gave a rounded amount, I need the exact 4 digit percent. Please help. Thanks!


See more 

2 replies

Best answer
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
5
Thank you
All you have to do is go to the format of the cell and change it two 4 decimal position. By default it is 2

Say "Thank you" 5

A few words of thanks would be greatly appreciated. Add comment

CCM 2943 users have said thank you to us this month

Posts
8928
Registration date
Friday May 15, 2009
Last seen
October 7, 2010
0
Thank you
Hi there,

You entered the correct formula,please give example of needed output.link below may be useful to you :

http://office.microsoft.com/en-us/excel-help/text-value-format-text-HP010062580.aspx

Thanks