Nested "If Statement"

[The Greek]

I am trying to write a "Nested If Statement". The purpose is to pick
the correct grade if it fails within a cetain range. I have dont
everything write. However, I discovered that I cant write more than 7
statements.

The grading system is more than 10 grades.

Please help..

Thank you

EZZAT

 

[Sandy Mann]

One way:

=LOOKUP(F5,{0,40,45,50,55,60,72,76,79,82,85,89,92,95,99},{"O","N","M","L","K","J","I","H","G","F","E","D","C","B","A"})

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Sandy Mann]

Or to make it easier to maintain, with the scores in K1:K15 and the grades
in L1:L15 try:

=LOOKUP(F5,K1:K15,L1:L15)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[The Greek]

Thank Sandy, The problem I have is that the score are in decimal and
will be falling in ranges, they are not absolute integers. Otherwise
I would have used the lookup formula.

Anyway idea..

 

[Sandy Mann]

Thank Sandy, The problem I have is that the score are in decimal and

will be falling in ranges, they are not absolute integers.

That should not be a problem. From XL Help on LOOKUP:

*If LOOKUP can't find the lookup_value, it matches the largest value in
lookup_vector that is less than or equal to lookup_value.*

It will therefore work with your decimal numbers.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk


Thank Sandy, The problem I have is that the score are in decimal and
will be falling in ranges, they are not absolute integers. Otherwise
I would have used the lookup formula.

Anyway idea..