Embedded IF Fuction

[Redhead]

I would like to use the IF function to return a grade value for a score. Ex:

If grade>70, then C
IFgrade>80, then B, and so on.

I believe I need to imbed this function but don't know how. Please advise?

Thanks in advance.

[PCLIVE]

One way:
You'll need to adjust the number grades as appropriate, but this should
help.

=IF(AND(A1>70,A1<81),"C",IF(AND(A1>80,A1<95),"B",IF(A1>94,"A")))

Regards,
Paul

"Redhead" <[email protected]> wrote in message
news:[email protected]...
>I would like to use the IF function to return a grade value for a score.
>Ex:
>
> If grade>70, then C
> IFgrade>80, then B, and so on.
>
> I believe I need to imbed this function but don't know how. Please
> advise?
>
> Thanks in advance.

[Redhead]

Thanks. I tried it exactly as entered, and I still get an "invalid" error.

"PCLIVE" wrote:

> One way:
> You'll need to adjust the number grades as appropriate, but this should
> help.
>
> =IF(AND(A1>70,A1<81),"C",IF(AND(A1>80,A1<95),"B",IF(A1>94,"A")))
>
> Regards,
> Paul
>
> "Redhead" <[email protected]> wrote in message
> news:[email protected]...
> >I would like to use the IF function to return a grade value for a score.
> >Ex:
> >
> > If grade>70, then C
> > IFgrade>80, then B, and so on.
> >
> > I believe I need to imbed this function but don't know how. Please
> > advise?
> >
> > Thanks in advance.
>
>
>

[PCLIVE]

Not sure why you would get "invalid". It seems to work on my side. If
there is more information that may be relevant, please post. Where does it
state "invalid"?

Regards,
Paul

"Redhead" <[email protected]> wrote in message
news:[email protected]...
> Thanks. I tried it exactly as entered, and I still get an "invalid"
> error.
>
> "PCLIVE" wrote:
>
>> One way:
>> You'll need to adjust the number grades as appropriate, but this should
>> help.
>>
>> =IF(AND(A1>70,A1<81),"C",IF(AND(A1>80,A1<95),"B",IF(A1>94,"A")))
>>
>> Regards,
>> Paul
>>
>> "Redhead" <[email protected]> wrote in message
>> news:[email protected]...
>> >I would like to use the IF function to return a grade value for a score.
>> >Ex:
>> >
>> > If grade>70, then C
>> > IFgrade>80, then B, and so on.
>> >
>> > I believe I need to imbed this function but don't know how. Please
>> > advise?
>> >
>> > Thanks in advance.
>>
>>
>>

[goober]

here is another way that might work for you.

=IF(A1<60,"F",IF(AND(A1>=60,A1<70),"D",IF(AND(A1>=70,A1<80),"C",IF(AND(A1>=80,A1<90),"B",IF(A1>=90,"A")))))