Support Board
Date/Time: Thu, 26 Jun 2025 13:30:54 +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
|