Login Page - Create Account

Support Board


Date/Time: Sat, 04 May 2024 01:17:02 +0000



Post From: SC does not recognize the formulas

[2022-12-30 15:53:41]
Hopeman - Posts: 156
Thank you Tomgilb!

I have a question that arises. I am with the spreadsheet system for trading trying to write the following formula in which I want that if the first condition is not met, that the second condition be met or that each one be an independent condition from one another but the two would go in the Buy entry box, I've given it a couple of turns and it gives me various types of errors. I'm a little lost on this topic, would you be so kind to help me,

This is the formula I'm trying to implement


=IF(AND(CROSSFROMBELOW(E3:E5,AB3:AB5), AND(CROSSFROMBELOW(AM3:AM5,AW3:AW5), O3, Q3)), IF(AND(CROSSFROMBELOW(E3:E5,AB3:AB5), CROSSFROMBELOW(M3:M5,AV3:AV5), O3, Q3)))

Best regards.