Skip to main content

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

Be the first to reply!

Reply