IF and Then Statement Survey123

[ablum]

I'm trying to write a calculation for a Status cell based multiple other cells.

Basically if cells A2, B2, C2, D2, E2 ='Pass' or 'Partial' then Status will equal 'PASS', but if any of them equal Fail, one 'Fail' should overwrite all Passes.

Example:

A2 ='Pass' or 'Partial', B2 ='Pass' or 'Partial', C2 ='Pass' or 'Partial', D2 ='Pass' or 'Partial', E2 ='Pass' or 'Partial'

Status='PASS'

Example 2:

A2 ='Pass' or 'Partial', B2 ='Pass' or 'Partial', C2 ='Pass' or 'Partial', D2 ='Pass' or 'Partial', E2 ='Fail'

Status='FAIL'

[jcarlson · Accepted solution]

It should be pretty easy with an if function. Rather than function the cells, use the field name. Try this:

if(${field1} = 'Fail' or ${field2} = 'Fail' or ${field3} = 'Fail' or ${field4} = 'Fail' or ${field5} = 'Fail', 'FAIL', 'PASS')

[ablum]

That worked, thank you!