Conditional formula
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
|