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!

MY FORMULA WILL NOT WORK
 

Maybe

=IF(C10=85.1,1,IF(C10=75.1,2,IF(C10=60,3,IF(C10 =55.1,4,IF(C100,5,IF(C10<=0,"N0 Score"))))))

Mike

"BOO19422" wrote:

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!

MY FORMULA WILL NOT WORK
 

start at the highest and work down
=IF(C1085,1,IF(C1075,2,IF(C1060,3,IF(C1055,4,I F(C10=0,5,0)))))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"BOO19422" wrote in message
...
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!

MY FORMULA WILL NOT WORK
 

Try this:

=LOOKUP(C10,{0,55.1,60,75.1,85.1},{5,4,3,2,1})

--
Biff
Microsoft Excel MVP


"BOO19422" wrote in message
...
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!

MY FORMULA WILL NOT WORK
 

That did the trick...Thanks for your help !!

"BOO19422" wrote:

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!

MY FORMULA WILL NOT WORK
 

We are ALL glad you liked it

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"BOO19422" wrote in message
...
That did the trick...Thanks for your help !!

"BOO19422" wrote:

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!