Skip to Content
0
Former Member
Nov 04, 2015 at 02:42 AM

IF....AND Formula result

40 Views

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