Login Page - Create Account

Support Board


Date/Time: Sat, 30 Nov 2024 02:35:08 +0000



Post From: SC does not recognize the formulas

[2022-12-30 15:53:41]
Hopeman - Posts: 166
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.