Hi there, can someone please help me finding the error in this formula? I just can´t see it.
IF [Tipo]="A" AND (ABS([Q1])>9000 OR ABS([Q4])>9000) AND ABS([Diferencia USD])>9000 THEN "Analyze" ELSE IF [Tipo]="B" AND (ABS([Q1])>9000 OR ABS([Q4])>9000) AND ABS([Diferencia USD])>9000 THEN "Analyze" ELSE "OK" ENDIF
Thanks in advance,
Solved! Go to Solution.
IF [Tipo]="A" AND (ABS([Q1])>9000 OR ABS([Q4])>9000) AND ABS([Diferencia USD])>9000 THEN "Analyze" ELSEIF [Tipo]="B" AND (ABS([Q1])>9000 OR ABS([Q4])>9000) AND ABS([Diferencia USD])>9000 THEN "Analyze" ELSE "OK" ENDIF