Menu
Ask a question Report

Calculating exact percentages in excel [Solved/Closed]

DL - Jun 8, 2010 at 11:10 AM - Latest reply: rizvisa1 4481 Posts Thursday January 28, 2010Registration dateContributorStatus January 6, 2016 Last seen
- Jun 8, 2010 at 03:51 PM
Excel Ask a question Report
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!


See more 

2 replies

Best answer
Report Respond to rizvisa1
rizvisa1 4481 Posts Thursday January 28, 2010Registration dateContributorStatus January 6, 2016 Last seen - Jun 8, 2010 at 03:51 PM
5
Thank you
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

Thank you, rizvisa1 5

Something to say? Add comment

CCM has helped 1831 users this month

Report Respond to closeup22
closeup22 8931 Posts Friday May 15, 2009Registration date October 7, 2010 Last seen - Jun 8, 2010 at 11:48 AM
0
Thank you
Hi there,

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

http://office.microsoft.com/en-us/excel-help/text-value-format-text-HP010062580.aspx

Thanks
Ask a question
Featured