I had it A1 >= 80 before and the complaint was that there is no cut off at 80. I fully agree with you that it should be a solution that is acceptable. I will give you a like because you thought exactly like I did the first time around. I have solved for not (since it has to be a nested IF statement) w/ A1 <= 80.Hi ,
Why not :
=IF(A1 >= 80;"A";IF(A1 >= 57;"B";IF(A1 >= 40;"C";"F")))
If A1 has any value of 80 or more , then the cell where this formula is entered will contain A ; for values between 57 and 79 inclusive , the cell will contain B , for values between 40 and 56 inclusive , the cell will contain C , and for all values less than 40 , the cell will contain F.
Is this not what you want ?
Narayan