Support Board

Date/Time: Thu, 26 Jun 2025 16:44:34 +0000

Post From: Crossover For Multiple values - spreadsheet

[2021-11-12 15:26:04] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4231
You must use ranges: =OR( CROSSOVER(AF3:AF4, AG3:AG4), CROSSOVER(AF3:AF4, AH3:AH4), CROSSOVER(AF3:AF4, AI3:AI4), CROSSOVER(AF3:AF4, AJ3:AJ4), CROSSOVER(AF3:AF4, AK3:AK4), CROSSOVER(AF3:AF4, AL3:AL4) )