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,7A2)) Hope this helps. Pete On May 12, 4:14 pm, desmond1412 <desmond1...(a)discussions.microsoft.com> 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: MsExlLearner 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!  (MsExlLearner)  "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,7A2)+1*(A2=3)+5*(A2=2)+10*(A2=1)  Wag more, bark less "MsExlLearner" 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! > >  > (MsExlLearner) >  > > > "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 passwordprotected document 