Nested IF,AND, OR

[voltrader]

Hey All,

I am trying to nest a function using the following formula

IF(OR(AND(AN4>=AM4),J4<=0,K4<=0,),"TRUE","NONE")

I am getting a result, but the result is not what I need. I want the formula to read as 'If AN4>=AM4, AND either J4<=0, OR K4<=0, then "TRUE, if not then "NONE".'

Any input greatly appreciated.
Elliot.

 

[Mindpsyche]

Try this untested:

=if(and(AN4=>AM4,or(J4<=0,K4<=0)),"TRUE","NONE")

 

[Special-K99]

Try
IF(AND(AN4>=AM4,OR(J4<=0,K4<=0,)),"TRUE","NONE")

 

[voltrader]

Try
IF(AND(AN4>=AM4,OR(J4<=0,K4<=0,)),"TRUE","NONE")

Yes that works!

Do you mind explaining, the syntax of the function? Why does the formula require a double parenthesis after the '0,' before the "TRUE",and "NONE"?

Thanks!
Elliot.