Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

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
 767
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,087
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!