Using Formula Tool - How to compare 2 columns with condition?

[ravikumar060987]

Dear All,

I have situation where need to compare 2 columns with conditions in both the columns, refer the below table. Please urge how I can write the formula in the Formula tool to get the output in simple way.

A	B	Output
01	1X, 1Y	TRUE
02	2A, 2B	TRUE
03	3D, 3E	TRUE

Without using any mapping?

[FinnCharlton]

Hi @ravikumar060987 , what logic are you using to get this output? What comparison are you doing? Can we have an example of when the output should be true and an example of when it should be false?

[ravikumar060987]

Hi @FinnCharlton 

Am looking something like - IF ([COL A] = 1) = (COL B = 1X & 1Y) THEN 'TRUE' ELSE 'FALSE' ENDIF. Is that possible?

[ShankerV]

Hi @ravikumar060987 

This formula will help you. Kindly check whether this you are looking for,

IF [A]="01" AND Contains([B],"1X") AND Contains([B],"1Y")
THEN "TRUE"
ELSE null()
ENDIF

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @ravikumar060987 

I have amended the formula as you need the result as False if the condition is failed.

IF [A]="01" AND Contains([B],"1X") AND Contains([B],"1Y")
THEN "TRUE"
ELSE "FALSE"
ENDIF

Many thanks

Shanker V