Login Page - Create Account

Support Board


Date/Time: Thu, 26 Jun 2025 16:53:25 +0000



Post From: Crossover For Multiple values - spreadsheet

[2021-11-12 14:43:11]
User337568 - Posts: 61
tomgib:

Thank you

Here's my interpretation of what you suggested:
1. Added Horizontal Line Study
2. Added values and double-checked that I am "Spreadsheet input - checked."

Result - CROSSOVER not working
AF3 - Variable
AG3 - 150 - Horizontal value - constant value
AH3 - (150)
AI3 - 300
AJ3 - (300)

=OR(
CROSSOVER(AF3, AG3),
CROSSOVER(AF3, AH3),
CROSSOVER(AF3, AI3),
CROSSOVER(AF3, AJ3),
CROSSOVER(AF3, AK3),
CROSSOVER(AF3, AL3)
)
Date Time Of Last Edit: 2021-11-12 14:44:03