All ,
I have an audit form.
The total points are cointed in a cell C62
See below.

Total points (total points C62)
Maximum possible points 705
Score in percentage

90% - 100% 634 - 705 Exceeds Requirements
80% - 90% 564 - 633 Acceptable:
70% - 80% 493 - 564 Minimally Acceptable
60% - 70% 423 - 492 Not Acceptable-Improvement Required
<60% <422 Not Acceptable:

My question is,

I want to implement a formula in Cell C63 if the score( in cellC62) is between 634 an 705 I see "Exceeds Requirements" in this cell.
So to be clear.If the value is between one of the above range of scores i want to see "Exceeds Requirements" or "Acceptable"or "Minimally Acceptable" ect ect.
Can someone give me tips how to do that?

Thanks in advance.

Tucka

In Cell C63 try something like the following (replace A1 with C62):

=IF(A1>=634,"Exceeds Requirements",IF(A1>=564,"Acceptable",IF(A1>=493,"Minimally Acceptable",IF(A1>=423,"Not Acceptable - Improvement Required","Not Acceptable"))))

HTH

Thanks,
He he he
You helped mealot.

Tucka

This is also a good example of where you can combine conditional formatting (e.g. if C63 says "Not Acceptable", then display as bold and red)