on 2015 Nov 04 2:42 AM
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
Patel,
You can even use
=IF [XXX]="T" AND [YYY]>1000 Then 0 else 50
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can try the below formula too and see if t works.
=IF([XXX]="T" ;IF([YYY]>1000;"0";"50");"50")
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Try this out,
(If[XXX]="T" then (if([YYY]=1000 then "0" else "50")
Regards,
Amit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
66 | |
10 | |
10 | |
10 | |
10 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.