Calculating exact percentages in excel

Solved/Closed
DL - 8 Jun 2010 à 11:10
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 8 Jun 2010 à 15:51
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 responses

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
8 Jun 2010 à 15:51
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
closeup22 Posts 8922 Registration date Friday 15 May 2009 Status Member Last seen 7 October 2010 2,099
8 Jun 2010 à 11:48