Previous Topic Next Topic

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!


Related:

2 replies

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

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

CCM 2942 users have said thank you to us this month

Answer 2 / 2
Posts
8926
Registration date
Friday May 15, 2009
Status
Member
Last seen
October 7, 2010
 2,105
Hi there,

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

https://support.microsoft.com/en-us/office/text-function-20d5ac4d-7b94-49fd-bb38-93d29371225c?ocmsassetid=hp010062580&correlationid=70c8536d-52b9-48ad-b2f9-9c19ab2ecd40&ui=en-us&rs=en-us&ad=us

Thanks
Ask a question