G Guest Nov 28, 2005 #1 suppose cells contain A, B, C and D which function do I have to use to print "pass" or "fail"
B Biff Nov 28, 2005 #2 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
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
P Peo Sjoblom Nov 28, 2005 #3 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)
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)
D David McRitchie Nov 28, 2005 #4 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/vlookup.htm#grading
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/vlookup.htm#grading
