=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