Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula help
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Regression Leverage Formula (Jerry W. Lewis or Mike Middleton)already have DFITS formula | Excel Worksheet Functions | |||
extract formula result form cell without running formula again | Excel Programming | |||
copy formula down a column and have cell references change within formula | New Users to Excel | |||
Formula expected end of statement error, typing formula into cell as part of VBA macro | Excel Programming | |||
Commenting custom formula fields/formula on formula editor | Excel Programming |