Support Board

Date/Time: Mon, 13 May 2024 11:49:58 +0000

Post From: CROSSFROMABOVE, CROSSFROMBELOW and CROSSOVER

[2021-10-29 13:39:53] Link To Thread - Link To Post [Go To First Post]
Botan626 - Posts: 294
When you say "the 3rd value", what value are you referring to? The 1 value in the 1st cell (I12), or the first value, when comparison is occurring and sets of data are inverted? The only time the 3rd value is looked at is when the 2nd values in each range are equal to each other. When the 2nd values in each range are equal to each other? You mean I13=J13? This doesn't sounds right. In the example in the 1st post crossover occurs between the points at rows 12 and 13, 2nd values are not equal to each other and CROSSFROMABOVE returns 1 correctly. If you will make a picture, like you did in the post #2, you will see clearly, that there is 1 crossover from above, so why CROSSFROMABOVE would return 0 then? Then, and only then, is the comparison performed to check the 1st value with the 3rd value. 1st value of the 1st set compares to the 3rd value of the same 2nd set? This makes no sense too. Does CROSSFROMABOVE work incorrectly after all? Date Time Of Last Edit: 2021-10-29 13:41:15