Nested "If Statement"

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

The Greek - 15 Mar 2008 18:57 GMT

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

Reply to this Message

Sandy Mann - 15 Mar 2008 19:23 GMT

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"})

Signature

HTH

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

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

>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
[quoted text clipped - 8 lines]
>
> EZZAT

Reply to this Message

Sandy Mann - 15 Mar 2008 19:44 GMT

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)

Signature

HTH

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

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

> One way:
>
[quoted text clipped - 12 lines]
>>
>> EZZAT

Reply to this Message

The Greek - 16 Mar 2008 06:17 GMT

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

> Or to make it easier to maintain, with the scores in K1:K15 and the grades
> in L1:L15 try:
[quoted text clipped - 39 lines]
>
> - Show quoted text -

Reply to this Message

Sandy Mann - 16 Mar 2008 12:43 GMT

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

Signature

HTH

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

sandymann2@mailinator.com
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..

On Mar 15, 9:44 pm, "Sandy Mann" <sandyma...@mailinator.com> wrote:

> Or to make it easier to maintain, with the scores in K1:K15 and the grades
> in L1:L15 try:
[quoted text clipped - 43 lines]
>
> - Show quoted text -

Reply to this Message