how to do i use a function if cells contain grades A B C f print.
 

suppose cells contain A, B, C and D which function do I have to use to print
"pass" or "fail"

how to do i use a function if cells contain grades A B C f print.
 

Hi!

It depends on which letters correspond to "Pass" or "Fail".

Using A, B, C and D. "D" is a failing grade. Assuming that a cell may only
contain either an A, B, C or D and nothing else.

A1= letter grade

=IF(A1="","",IF(A1="D","Fail","Pass"))

Biff

"fabien" wrote in message
...
suppose cells contain A, B, C and D which function do I have to use to
print
"pass" or "fail"

how to do i use a function if cells contain grades A B C f print.
 

It depends on what pass and fail are, is A and B pass and C and D fail?

=IF(OR(A1="A",A1="B"),"Pass","Fail")

--
Regards,

Peo Sjoblom

(No private emails please)


"fabien" wrote in message
...
suppose cells contain A, B, C and D which function do I have to use to
print
"pass" or "fail"

how to do i use a function if cells contain grades A B C f print.
 

Care to be more specific, if not, possibly you are talking about student test grades.
IF Worksheet Function

=IF(OR(A1="A", A1="B", A1="C", A1="D"), "pass", "fail")

=IF(A1"D", "fail","pass")

=IF(AND(A1="A",A1<="F"),IF(A1"D", "fail","pass"),"")

More on grading, not necessarily related to your question.
http://www.mvps.org/dmcritchie/excel...up.htm#grading

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"fabien" wrote in message ...
suppose cells contain A, B, C and D which function do I have to use to print
"pass" or "fail"