Support Board
Date/Time: Tue, 16 Sep 2025 08:50:17 +0000
Post From: CROSSFROMABOVE, CROSSFROMBELOW and CROSSOVER
| [2021-10-27 13:50:26] |
| 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
|