Well, now I'm not following you.

If you change A1 to 500, A1 is no longer the max value in the range and the
results would be:

...........A..........B
1.......500......280
2.......750... ..80
3.......600.... .200
4.......850..........0

It would help if you could should show us an example with the desired
results.

Biff

"Yan" wrote in message
...
OK! but my question is

That if in A1 the value is 500,
Therefore with the formulas, i am asking find the Maximum number in rows
A1:A10 witch equal to 500 and substract the same value, multuiply by
80%...

so basically, is 500-500*80%=0

"T. Valko" wrote:

Barb's formula produces these results which is what you asked for:

Team 2 gets 120pins Handicap
team 3 shoiuld have 240pins handicap and so on...

...........A..........B
1.......900.........0
2.......750.....120
3.......600.....240
4.......850.......40

Biff

"Yan" wrote in message
...
That does not work, cause you are saying to find the mx number in a
colums
and susbstarct that same number....

I tried it!

"Barb Reinhardt" wrote:

Correction

=(MAX(A$1:A$10)-A1)*0.8


"Yan" wrote:

hi!

What i am trying to do is to make a formulas on the master sheet
that
will
change weekly the Handicap of the teams...

Ex: T1 avergae is 900 and T2 is 750 = 150pts different now i need to
take
that different at a 80% value and giev it to team 2 score....

But, the problem i have is that, their is 10 Teams in the league,
therefore
the formuilas need to check the Teams average on the teams page and
then
assign the correct Handicap to each team in the master sheets...

Ex: T1 = 900 ave.
t2 = 750
T3=600
T4= 850

Ok, now team 1 and Team 2 are 150pins different at 80%, so Team 2
gets
120pins Handicap

Team 1 and Team 3 ahve 300 pins different at 80%, so team 3 shoiuld
have
240pins handicap and so on...

Basically, the Highest average Team, gives Handicap to other
teams....This
can change weekly, Team or Handicap..

Thx you!