From: desmond1412 on 12 May 2010 11:14 trying to construct a formula for the following for the same cell: if a2 > 6, then e2 = 0 if a2 = 6, then e2 = 1 if a2 = 5, then e2 = 2 if a2 = 4, then e2 = 3 if a2 = 3, then e2 =5 this is for a golf scoring system. a2 values are hole scores and results are "handicap" point scores. Any help greatly appreciated From: Pete_UK on 12 May 2010 11:24 Try this: =IF(A2>6,0,IF(A2<=3,5,7-A2)) Hope this helps. Pete On May 12, 4:14 pm, desmond1412 wrote:> trying to construct a formula for the following for the same cell: > if a2 > 6, then e2 = 0 > if a2 = 6, then e2 = 1 > if a2 = 5, then e2 = 2 > if a2 = 4, then e2 = 3 > if a2 = 3, then e2 =5 > > this is for a golf scoring system.  a2 values are hole scores and results > are "handicap" point scores.  Any help greatly appreciated From: Ms-Exl-Learner on 12 May 2010 11:32 Copy and paste the below formula in E2 cell. =IF(A2>6,0,IF(A2=6,1,IF(A2=5,2,IF(A2=4,3,IF(A2=3,5,""))))) -- Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "desmond1412" wrote: > trying to construct a formula for the following for the same cell: > if a2 > 6, then e2 = 0 > if a2 = 6, then e2 = 1 > if a2 = 5, then e2 = 2 > if a2 = 4, then e2 = 3 > if a2 = 3, then e2 =5 > > this is for a golf scoring system. a2 values are hole scores and results > are "handicap" point scores. Any help greatly appreciated From: Brad on 12 May 2010 11:55 Another approach =Max(0,7-A2)+1*(A2=3)+5*(A2=2)+10*(A2=1) -- Wag more, bark less "Ms-Exl-Learner" wrote: > Copy and paste the below formula in E2 cell. > =IF(A2>6,0,IF(A2=6,1,IF(A2=5,2,IF(A2=4,3,IF(A2=3,5,""))))) > -- > Remember to Click Yes, if this post helps! > > -------------------- > (Ms-Exl-Learner) > -------------------- > > > "desmond1412" wrote: > > > trying to construct a formula for the following for the same cell: > > if a2 > 6, then e2 = 0 > > if a2 = 6, then e2 = 1 > > if a2 = 5, then e2 = 2 > > if a2 = 4, then e2 = 3 > > if a2 = 3, then e2 =5 > > > > this is for a golf scoring system. a2 values are hole scores and results > > are "handicap" point scores. Any help greatly appreciated  |  Pages: 1 Prev: Colours in Print preview?Next: Exception to password-protected document