View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PCLIVE
 
Posts: n/a
Default 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.