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

Sandy
Sat Mar 15 13:23:53 CDT 2008

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

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


"The Greek" <izzalzurba@gmail.com> wrote in message
news:ecb3d80b-c0c4-430b-814d-bb926622ad2f@i7g2000prf.googlegroups.com...
>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
Sat Mar 15 13:44:13 CDT 2008

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

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


"Sandy Mann" <sandymann2@mailinator.com> wrote in message
news:uyaWBnshIHA.3400@TK2MSFTNGP03.phx.gbl...
> 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
>
> sandymann2@mailinator.com
> Replace @mailinator.com with @tiscali.co.uk
>
>
> "The Greek" <izzalzurba@gmail.com> wrote in message
> news:ecb3d80b-c0c4-430b-814d-bb926622ad2f@i7g2000prf.googlegroups.com...
>>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
>>
>
>
>

The
Sun Mar 16 00:17:17 CDT 2008

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=A0pm, "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:
>
> =3DLOOKUP(F5,K1:K15,L1:L15)
>
> --
> HTH
>
> Sandy
> In Perth, the ancient capital of Scotland
> and the crowning place of kings
>
> sandyma...@mailinator.com
> Replace @mailinator.com with @tiscali.co.uk
>
> "Sandy Mann" <sandyma...@mailinator.com> wrote in message
>
> news:uyaWBnshIHA.3400@TK2MSFTNGP03.phx.gbl...
>
>
>
> > One way:
>
> > =3DLOOKUP(F5,{0,40,45,50,55,60,72,76,79,82,85,89,92,95,99},{"O","N","M",=
"L","=ADK","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
>
> > sandyma...@mailinator.com
> > Replace @mailinator.com with @tiscali.co.uk
>
> > "The Greek" <izzalzu...@gmail.com> wrote in message
> >news:ecb3d80b-c0c4-430b-814d-bb926622ad2f@i7g2000prf.googlegroups.com...
> >>I am trying to write a "Nested If Statement". =A0The purpose is to pick
> >> the correct grade if it fails within a cetain range. =A0I have dont
> >> everything write. =A0However, 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 -

Sandy
Sun Mar 16 06:43:42 CDT 2008

>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

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


"The Greek" <izzalzurba@gmail.com> wrote in message
news:23437a40-9f6b-4dd7-a469-3c96b22e0c80@59g2000hsb.googlegroups.com...
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:
>
> =LOOKUP(F5,K1:K15,L1:L15)
>
> --
> HTH
>
> Sandy
> In Perth, the ancient capital of Scotland
> and the crowning place of kings
>
> sandyma...@mailinator.com
> Replace @mailinator.com with @tiscali.co.uk
>
> "Sandy Mann" <sandyma...@mailinator.com> wrote in message
>
> news:uyaWBnshIHA.3400@TK2MSFTNGP03.phx.gbl...
>
>
>
> > 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
>
> > sandyma...@mailinator.com
> > Replace @mailinator.com with @tiscali.co.uk
>
> > "The Greek" <izzalzu...@gmail.com> wrote in message
> >news:ecb3d80b-c0c4-430b-814d-bb926622ad2f@i7g2000prf.googlegroups.com...
> >>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 -