is there a formula to show the diference between numbers?
 

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

is there a formula to show the diference between numbers?
 

possibly

=4-6

Mike

"Ollie" wrote:

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

is there a formula to show the diference between numbers?
 

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

"Mike H" wrote:

possibly

=4-6

Mike

"Ollie" wrote:

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

is there a formula to show the diference between numbers?
 

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
--
Kevin Backmann


"Ollie" wrote:

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

is there a formula to show the diference between numbers?
 

=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.
--
David Biddulph

"Ollie" wrote in message
...
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

"Mike H" wrote:

possibly

=4-6

Mike

"Ollie" wrote:

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