Hello! I’m having trouble with a formula. I hope someone can help:)
Issue:
Certificate program provides two chances for someone to pass the course. If a person “passes” Quiz 1, they automatically pass the course. If they don’t pass, they can try it again with Quiz 2. If they pass Quiz 2, they pass the course.
I need to create a column that states that if there is a “pass” in either Quiz 1 or Quiz 2, they pass the course. I’ve been writing out formulas and I’m getting some things wrong. Can someone help me figure this out?
Options: Pass, Did not pass, Not Started
These are some of the examples I’ve been writing the formula in a third column called “Final Results”. I want this column to read “pass” or “did not pass”. This is the column that will be exported to a certificate platform that specifies only one field for people who pass.
IF((Q1 IS_SAME(pass) OR(Q2 IS_SAME(pass)))
IF({Q1}IS_SAME(Pass),IF({Q2}IS_SAME(Pass),“Pass”)
IF(){Q1}IS_SAME(Pass),
IF(){Q2}IS_SAME(Pass),“Pass”)
IF(
{Quiz 1: Result} IS_SAME(pass),
“pass”,
IF({Quiz 2: Result} IS_SAME(Not started,Did Not Pass),
“Did Not Pass”,
“pass”
)
)
Thanks so much!
Julia
