Conditional formula

[desmond1412]

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

 

[Pete_UK]

Try this:

=IF(A2>6,0,IF(A2<=3,5,7-A2))

Hope this helps.

Pete

 

[Ms-Exl-Learner]

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,"")))))

 

[Brad]

Another approach
=Max(0,7-A2)+1*(A2=3)+5*(A2=2)+10*(A2=1)