Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Fri, 03 May 2024 22:17:47 +0000

How to Post a Message for Support

Post From: Spreadsheet trading question about using IF for multiple entries??

[2014-06-06 17:32:01]
[Go To First Post]
Sawtooth - Posts: 3993
Assuming your order quantity is 1, and you only want to add to the position once, here's a simplistic way:

=OR(AND($J$8=0,AA4>AG4,AA5<AG5,AG4>AC4,AG4>AE4,E4>AG4),AND($J$8=0,AA4>AE4,AA5<AE5,AE4>AC4,AE4>AG4,E4>AE4),AND($J$8=1,AA4>AC4,AA5<AC5,AC4>AG4,AC4>AE4,E4>AC4))

There are other more involved ways to do it in different situations.