Help

Having trouble with writing the right formula for IF Conditional drawing from two columns to have results in a third column

Topic Labels: Formulas
435 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Julia_Moreno_Pe
4 - Data Explorer
4 - Data Explorer

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

0 Replies 0