Nested AND statements

[b86]

Hi all,

I'm trying to work out a formula with multiple AND statements, but I can seem to get the syntax right. Right now I have 

if ([Total_Score]>= 0 AND [Total_Score]<= 7) AND

([Nbr_Sim]>=0.5 AND [Address_Score]<4) AND

([StreetTag_Sim]>= 0.5 OR [Place_Sim] >= 0.5) THEN "CHECK" ELSE " " Endif

This doesnt seem to work as I am finding values outside of my parameters popping up. Any help would be greatly appreciated!

[JagdeeshN · Accepted solution]

@b86 

Please refer to the attached workflow sample. I created a sample input and the formula seems to work.

Have you checked the data types of all the columns you are using in the formula?

Best,

Jagdeesh 

[danilang]

Hi @b86 

As @JagdeeshN mentioned, the syntax of the IF statement is correct.  However, that doesn't mean that it performs the operation that you're looking for. 

Can you post some sample data and your expected output, highlighting that values that are not matched by the statement

Dan