Thread
:
formula help
View Single Post
#
2
Posted to microsoft.public.excel.programming
Bob Phillips[_4_]
external usenet poster
Posts: 834
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.
Reply With Quote
Bob Phillips[_4_]
View Public Profile
Find all posts by Bob Phillips[_4_]