Full Version: If / or question
Tucka01
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?

Tucka
sleepy_chicken
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
Tucka01
Thanks,
He he he
You helped mealot.

Tucka
sleepy_chicken
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)