Calculating exact percentages in excel [Solved/Closed]

Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
760
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
Thank you

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

CCM 2942 users have said thank you to us this month

Posts
8928
Registration date
Friday May 15, 2009
Status
Member
Last seen
October 7, 2010
2,096