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