How to do a 4 way column compare?

[wonka1234]

How do I compare these 4 columns?

I want a column to show 0 if all 4 of the value columns are equal.

[Robin_McIntosh]

If/Then/Esle

[wonka1234]

@Robin_McIntosh 

thanks robin, but what if a column has 0 already? How can I account for that? 

Ie the value 4th column has a 0, i want the new col to show 0 still if one of the comparison columns have 0.

[Emmanuel_G]

Hi @wonka1234  ,

Do you want something like this ?

[wonka1234]

@Emmanuel_G  

Yes - but i prefer the output to be "pass" or "fail" 

also it will just be comparing numbers

but also there could be 0's in the comparison columns!

[Robin_McIntosh]

@wonka1234 - Could there be more than 1 col that is already 0?  For instance can Col1 be > 0 and the other 3 cols = 0?

[wonka1234]

@Robin_McIntosh  Yes. Any of the 4 comparison columns could have 0.

[Emmanuel_G]

@wonka1234 ,

Try watching this and tell me if this is the output you want.

[Emmanuel_G]

@wonka1234  I just edited in the test above to do an OK comparison test if there is 0 only in the 4 fields.

[wonka1234]

@Emmanuel_G 

Thanks, see the highlight in red, should be pass. IF the values are the same OR values are same and has a 0 in any column then Pass, if not the same, faill.