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

If grade70, then C
IFgrade80, then B, and so on.

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

Thanks in advance.

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

=IF(AND(A170,A1<81),"C",IF(AND(A180,A1<95),"B",I F(A194,"A")))

Regards,
Paul

"Redhead" wrote in message
...
I would like to use the IF function to return a grade value for a score.
Ex:

If grade70, then C
IFgrade80, then B, and so on.

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

Thanks in advance.

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(A170,A1<81),"C",IF(AND(A180,A1<95),"B",I F(A194,"A")))

Regards,
Paul

"Redhead" wrote in message
...
I would like to use the IF function to return a grade value for a score.
Ex:

If grade70, then C
IFgrade80, then B, and so on.

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

Thanks in advance.

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" wrote in message
...
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(A170,A1<81),"C",IF(AND(A180,A1<95),"B",I F(A194,"A")))

Regards,
Paul

"Redhead" wrote in message
...
I would like to use the IF function to return a grade value for a score.
Ex:

If grade70, then C
IFgrade80, then B, and so on.

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

Thanks in advance.

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


--
goober
------------------------------------------------------------------------
goober's Profile: http://www.excelforum.com/member.php...o&userid=19838
View this thread: http://www.excelforum.com/showthread...hreadid=507785