If formula issue

Hi,

I am having an issue with an IF formula and i am damned if i can see what I've done wrong!

The rules are:

score is greater than 90 - A
score is 80-89 - B
score is 70-79 - C
score is 60-69 - D
score is less than 60 - Shouldn't be working for us
score is 0 - N/A

I have entered the following but i am obviously missing something.

=IF([@[Total (100)]]>=90,"A",IF([@[Total (100)]]>=80,"B",IF([@[Total (100)]]>=70,"C",IF([@[Total (100)]]>=60,"D",IF(AND([@[Total (100)]]<60,[@[Total (100)]]>0,"Shouldn't be working for us",IF([@[Total (100)]]=0,"N/A")))

Thanks in advance

Steve
Sample below
IF Formula Query.xlsx

Cell I2 formula

Formula:

Please Login or Register  to view this content.

OR

Formula:

Please Login or Register  to view this content.

Hi,

Never used a lookup formula before. How does it work if i want any 0 calculations to = N/A

Cell I2 formula

Formula:

Please Login or Register  to view this content.

Or

Formula:

Please Login or Register  to view this content.

You're Welcome. Glad to help . Thank You for the feedback and rep.