formula help
 

my formula is:
=IF(E24,B2+4,IF(E2=3.5,B2+4,IF(E2=3,B2+E2,IF(E2=2 .5,B2+3,IF(E2=2,B2+E2,IF(E2=1.5,B2+2,IF(E2=1,B2+E2 ,IF(E2=0.5,B2+1,IF(E2=-2,B2+E2,IF(E2=-1.5,B2-2,IF(E2=-1,B2+E2,IF(E2=-0.5,B2-1,IF(E2<-2,B2-2))))))))))))
Whats wrong? Why is it not working?

To explain, I'm making a score chart for a golf tournament.
A2 = NAME
B2 = Handicap
C2 = New Score
D2 = Difference (C2-B2)
E2 = D2 divided by 2 (D2/2)
F2 = New Handicap

Bad players get a handicap, so when they play against good players they have
some kind of chanve to win.
The New handicap is figured like so: Handicapp minus the New Score divided
by 2 this number is added to the original handicapp, but can only go up by 4
points or down by 2.

formula help
 

Try this

=MAX(IF(E20,4,-2),ROUNDUP(E2,0))

--

HTH

Bob

"Formula Help" <Formula wrote in message
...
my formula is:
=IF(E24,B2+4,IF(E2=3.5,B2+4,IF(E2=3,B2+E2,IF(E2=2 .5,B2+3,IF(E2=2,B2+E2,IF(E2=1.5,B2+2,IF(E2=1,B2+E2 ,IF(E2=0.5,B2+1,IF(E2=-2,B2+E2,IF(E2=-1.5,B2-2,IF(E2=-1,B2+E2,IF(E2=-0.5,B2-1,IF(E2<-2,B2-2))))))))))))
Whats wrong? Why is it not working?

To explain, I'm making a score chart for a golf tournament.
A2 = NAME
B2 = Handicap
C2 = New Score
D2 = Difference (C2-B2)
E2 = D2 divided by 2 (D2/2)
F2 = New Handicap

Bad players get a handicap, so when they play against good players they
have
some kind of chanve to win.
The New handicap is figured like so: Handicapp minus the New Score divided
by 2 this number is added to the original handicapp, but can only go up by
4
points or down by 2.