calculating differences

[bluesky]

I have a series of worksheets with numbers in a column that range from low to high. The numbers are different in each worksheet but the format is the same. I need a formula that can calculate for each worksheet the difference between each number and the highest number in that worksheet: e.g. worksheet 1 might be the numbers 2, 6, 8 and I need the calculated numbers 6, 2, 0. (i.e. 8-2; 8-6 and 8-8) I can't enter a manual formula for each cell each time. Any suggestions? and thanks.

[c_m]

Try:
=MAX($A$1:$A$20)-A1
and copy down

where A1:A20 is your range of numbers

[bluesky]

Perfect! Thanks. Problem solved.