Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Mon, 29 Apr 2024 09:41:39 +0000
Post From: time function
| [2014-12-02 13:58:11] |
| Sawtooth - Posts: 3982 |
|
That formula will return a -1 if cross from below, and a 1 if cross from above. You could use the CROSSFROMBELOW and CROSSFROMABOVE functions in K3 and M3 respectively, or you could use the CROSSOVER function and write the K3 and M3 formulas to separate the 1s from the -1s. But try this instead: K3: =AND(AD4>AC4,AC3>AD3) M3: =AND(AD4<AC4,AC3<AD3) Notice the only change is the direction of the operators. |