Skip to Content
avatar image
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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    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

    Add comment
    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

  • avatar image
    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")

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 05, 2015 at 01:02 AM

    Patel,

    You can even use

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

    Add comment
    10|10000 characters needed characters exceeded