Nested "If Statement"
 

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

Nested "If Statement"
 

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


Replace @mailinator.com with @tiscali.co.uk


"The Greek" wrote in message
...
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

Nested "If Statement"
 

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


Replace @mailinator.com with @tiscali.co.uk


"Sandy Mann" wrote in message
...
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


Replace @mailinator.com with @tiscali.co.uk


"The Greek" wrote in message
...
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

Nested "If Statement"
 

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..


On Mar 15, 9:44*pm, "Sandy Mann" wrote:
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


Replace @mailinator.com with @tiscali.co.uk

"Sandy Mann" wrote in message

...



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


Replace @mailinator.com with @tiscali.co.uk

"The Greek" wrote in message
...
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- Hide quoted text -

- Show quoted text -

Nested "If Statement"
 

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


Replace @mailinator.com with @tiscali.co.uk


"The Greek" wrote in message
...
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..


On Mar 15, 9:44 pm, "Sandy Mann" wrote:
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


Replace @mailinator.com with @tiscali.co.uk

"Sandy Mann" wrote in message

...



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


Replace @mailinator.com with @tiscali.co.uk

"The Greek" wrote in message
...
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- Hide quoted text -

- Show quoted text -