Login Page - Create Account

Support Board


Date/Time: Wed, 01 May 2024 21:46:09 +0000



Post From: Spreadsheet trading question

[2014-03-01 03:00:21]
vegasfoster - Posts: 444
I think what you are asking how to enter if condition 2 is true, but only if condition 1 is also true. In that case you would use,

=if(AND(AA3>AG3,AA4<AG4,AG3>AC3,AG3>AE3,AG3>AI3), if(AND(AA3>AE3,AA4<AE4,E3>AC3,AE3>AG3,AE3>AI3), True, False), False)

If condition 1 can result in an entry and then later condition 2 could result in additional entry, but only if condition 1 is currently in a position, then let me because that would be different.