View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BOO19422 BOO19422 is offline
external usenet poster
 
Posts: 2
Default MY FORMULA WILL NOT WORK

This is the formula I have and the chart I'm using can anyone help?

=IF(C10<=55,5,IF(C10=0,"NO
VALUE",IF(C10=85.1,1,IF(C10=75.1-85,2,IF(C10=60-75,3,IF(C10=55.1-59.99,4))))))

0-55 will be 5 points.
55.1-59.99 will be 4 points
60-75 will be 3 points
75.1-85 will be 2 points
85.1 and up will be 1 point

1 is highest!