how can i get %. like 100+85+75+96=89.0%

G

Guest

Same way you did on the calculator? =(100+85+75+96)/4, or with your values
in say B2:E2, then in F2 enter =SUM(B2:E2)/4. If you want it displayed as %,
devide by a further 100, format cell as percentage, 1 decimal point -
=SUM(B2:E2)/400, or =(100+85+75+96)/400, or else enter the values as
percentages 1, 0.85, 0.75 and 0.96, and then devide by 4 at the end
 
G

Guest

Same way you did on the calculator? =(100+85+75+96)/4, or with your values
in say B2:E2, then in F2 enter =SUM(B2:E2)/4. If you want it displayed as %,
devide by a further 100, format cell as percentage, 1 decimal point -
=SUM(B2:E2)/400, or =(100+85+75+96)/400, or else enter the values as
percentages 1, 0.85, 0.75 and 0.96, and then devide by 4 at the end
 
T

Trevor Shuttleworth

Looks more like an average than a percentage

Add them up, divide by the number of entries

=(100+85+75+96)/4

If you do want it to look like a percentage:

=(100+85+75+96)/4/100 and format as percentage

Regards

Trevor
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sum data in a range? 12
Ranking on a report 3
VLOOKUP 2
scatter plot 2
Scatter Chart 1
Payment calculation 1
vba code to get an duse the value from a particular cell 3
Position in a list of numbers 3

Top