is there a formula to show the diference between numbers?

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
 
O

Ollie

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
 
K

Kevin B

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
 
D

David Biddulph

=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.
 
Top