Support Board

Date/Time: Mon, 13 May 2024 17:28:10 +0000

Post From: CROSSFROMABOVE, CROSSFROMBELOW and CROSSOVER

[2021-10-27 13:50:26] Link To Thread - Link To Post [Go To First Post]
Botan626 - Posts: 294
In I12-I14 cells I have 1, 6, 5 values. In J12-J14 cells I have 3, 4, 2 values. =CROSSFROMABOVE(I12:I14, J12:J14) returns 1 =CROSSFROMBELOW(I12:I14, J12:J14) returns 0 =CROSSOVER(I12:I14, J12:J14) returns -1 So CROSSFROMABOVE and CROSSFROMBELOW say 'The first range crosses the second Range from above.', CROSSOVER says 'The first Range crosses the second Range from below.'. Why different results? My logic says, that only CROSSOVER gives a correct return value. Date Time Of Last Edit: 2021-10-27 14:06:30