View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
desmond1412 desmond1412 is offline
external usenet poster
 
Posts: 1
Default Conditional formula

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