Proper "AND" & "OR" Syntax

[AdamW328]

Hi, I am looking for the syntax for this:

IF L20="Buy $3K” OR L23="Sell $3K” AND D23>D26*1.025 AND D23<D24 than “Close all”


This is what I came up with and it is not working:

=IF(OR(L20="Buy $3K”, L23="Sell $3K”, AND(D23>D26*1.025, D23<D24)), "Close all”, "")


Can someone please help

Thanks

[FlameRetired]

This is just a guess from your description and sense of the formula.

Please Login or Register  to view this content.

[AdamW328]

That did it, thanks!

[FlameRetired]

You're welcome. Thanks for the feedback.