Prev: Colours in Print preview?
Next: Exception to password-protected document
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
<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: 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