| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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" |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I print current row in same place on paper but not print surrounding cells??? | New Users to Excel | |||
| print view & print, in excel, different size cells | Excel Discussion (Misc queries) | |||
| I need to print cells under the orginal line instead of page break | Excel Discussion (Misc queries) | |||
| Using SUM function with #N/A in some cells | Excel Worksheet Functions | |||
| Custom Function not being auto calculated when cells change..help? | Excel Worksheet Functions | |||
Threaded Mode
