formula help

F

Formula Help

my formula is
=IF(E2>4,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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top