Hi!
How is your data setup?
> I list them as Test 1, Test 2, and Test 3 with their names down the side.
That's not a very good description! Be VERY specific!
How do you denote whether someone passed (or failed) a test? P? F?
Biff
"Chrissi" <[email protected]> wrote in message
news:[email protected]...
> Hi, I am a student teacher using Excel 2003 for my marking. So far, I have
> not had too many problems writing formulas but this one has me stumped.
> To get a pass in their snap tests the students must pass 2 out of three
> tests. I list them as Test 1, Test 2, and Test 3 with their names down the
> side.
> So I need to write a formula to test for all possible outcomes that will
> result in a pass. Student can either pass Test 1 and Test 2 or Test 1 and
> Test 3 or Test 2 and Test 3
> I want to write the formulas so that the auto answer will be either "
> Student Passed" or "Student Failed". I can understand that I need "If"
> "And"
> "Or" and I can get some of them to work but not all. Would SKS please
> help.
> Regards Chrissi
Bookmarks