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

Try this:

=IF(A26,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

Copy and paste the below formula in E2 cell.
=IF(A26,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

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(A26,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