Support Board
Date/Time: Tue, 04 Mar 2025 14:19:58 +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
|