Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Thu, 26 Jun 2025 17:02:34 +0000

How to Post a Message for Support

Post From: Crossover For Multiple values - spreadsheet

[2021-11-12 02:20:08]
[Go To First Post]
User337568 - Posts: 61
Hi:

I am using this formula in a spreadsheet and I am not getting any hits.

=OR (
CROSSOVER(AF3, -150),
CROSSOVER(AF3, -350),
CROSSOVER(AF3, -750),
CROSSOVER(AF3, 150),
CROSSOVER(AF3, 300),
CROSSOVER(AF3, 750))

AF3 is a variable, but I am using constants for the crossovers.

The output is "0."

I can get hits with this formula
=OR(AF3 > 150, AF3<- 150)

However, I would like the CROSSOVER formula to work.