Embedded IF Fuction

R

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

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
 
P

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
 
G

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