is there a formula to show the diference between numbers?

  • Thread starter Thread starter Ollie
  • Start date Start date
O

Ollie

i am crsting a spreadsheet where i will need to show the difference between
one set of numbers and the average set of numbers but i am not sure how to do
this.
i.e average score is 6 and their score is 4 i would need it to show -2
 
hi thanks for that, however there ae 25 average scores on 5 different
matters, not all of them ae going to = -2 so i need a formula that will work
in all scenarios.
Regards
Ollie
 
The difference would be their score minus the average value. So if their
score is in cell B1 and the Average is in cell A1 the formula would be:

=B1-A1
 
=A2-B2, where A2 is the cell in which you calculate your value of 4, and B2
is the cell where you calculate your value of 6.
 

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

Ranking Top 5 in score and percentage 1
Average cells based on column header 6
hiding zero for a sum 3
How do you apply criteria in order of preference? 3
Averages - Golf League Scoring 12
count array for top three entries and return their number 4
Count based on cell value between two numbers 4
Another golf handicap question 5

Back
Top