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!
Solved! Go to Solution.
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
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