Multiple conditions for IF statement

Originally Posted by guilbj2

I'm trying to calculate a rating from 1-5 based on a number of occurences of an event (errors by staff members) using the following formula:

=IF(J6<=1,"1"),IF(J6<=3,"2"),IF(J6<=5,"3"),IF(J6<=7,"4"),IF(J6>7,"5")

Essentially, J6 holds the value for the number of errors the staff member has made. 0-1 errors would get a rating of 1, 2-3 errors a rating of 2, 4-5 errors a rating of 3, 6-7 errors a rating of 4 and 8 or more errors a rating of 5. The formulas I've created is giving me a #VALUE! error and I cant' figure out why. Any suggestions would be great.

You can simply rearrange your parentheses (and maybe, you can also take the "quote marks" from the numbers:

=IF(J6<=1,1,IF(J6<=3,2,IF(J6<=5,3,IF(J6<=7,4,5))))

Originally Posted by guilbj2

Works like a charm, thanks very much for the assitance !

You're welcome and thanks for the feedback. I am just glad that I can be of help.