Calculating exact percentages in excel
Solved/Closed
DL
-
Jun 8, 2010 at 11:10 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 8, 2010 at 03:51 PM
rizvisa1 Posts 4478 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!
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:
- How to find the exact percentage of a number
- Percentage formula in excel marksheet - Guide
- How to check ps4 controller battery percentage - Guide
- How to calculate daily attendance percentage - Excel Forum
- How to get exact coordinates on google earth - Guide
- Percentage - Office Software Forum
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 8, 2010 at 03:51 PM
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
closeup22
Posts
8922
Registration date
Friday May 15, 2009
Status
Member
Last seen
October 7, 2010
2,099
Jun 8, 2010 at 11:48 AM
Jun 8, 2010 at 11:48 AM
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
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