IF....AND Formula result

[Former Member]

Hi Guys,

I have a formula for IF.. AND that is correct however does not return correct result.

I have used IF(([XXX]="T" AND [YYY]>1000);"0","50")

If I break this formula with only one condition it works however as soon as I use AND, the result  always returns "50" even if YYY is greater than 1000.

Anyone who can help would be appreciated.

Thanks

[Former Member]

Patel,

You can even use

=IF [XXX]="T" AND [YYY]>1000 Then 0 else 50

[former_member189638]

You can try the below formula too and see if t works.

=IF([XXX]="T" ;IF([YYY]>1000;"0";"50");"50")

[former_member220624]

Hi,

Try this out,

(If[XXX]="T" then (if([YYY]=1000 then "0" else "50")

Regards,

Amit

[Former Member]

Hi Amit, the problemas with your fórmula is that IF [xxx] happens to be not equal 'T' it will returno null, not 50.

I think that the better approach would be enclosing each condition into parêntesis :

IF(([XXX]="T" ) AND ([YYY]>1000);"0","50")

Regards,

Rogerio