Calculating exact percentages in excel

Solved/Closed
DL - Jun 8, 2010 at 11:10 AM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- 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!


2 replies

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Jun 8, 2010 at 03:51 PM
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
5
closeup22
Posts
8925
Registration date
Friday May 15, 2009
Status
Member
Last seen
October 7, 2010
2,108
Jun 8, 2010 at 11:48 AM
0