Former Member

### IF....AND Formula result

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

10|10000 characters needed characters exceeded

• Former Member
Nov 04, 2015 at 08:18 AM

Hi,

Try this out,

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

Regards,

Amit

10|10000 characters needed characters exceeded
• 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

• Former Member
Nov 04, 2015 at 09:15 PM

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

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