View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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