If and then else condition usage

[Sethuram]

How do I use a formula to check if condition satisfies in two columns and take action based on the result?

[atcodedog05 · Accepted solution]

Hi @Sethuram 

You can use And (both satisfies) Or (satisfies either) for this formula would be like below. Where [Name] and [ID] are 2 columns.

Both satisfy

IF [Name]="A" and [ID]=1 THEN "Y" ELSE "N" ENDIF

Either satisfy

IF [Name]="A" or [ID]=1 THEN "Y" ELSE "N" ENDIF

Hope this helps : )

[atcodedog05]

Happy to help : ) @Sethuram 

Cheers and have a nice day!