Embedded IF Fuction
 

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.

Embedded IF Fuction
 

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.

Embedded IF Fuction
 

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.

Embedded IF Fuction
 

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.

Embedded IF Fuction
 

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