Support Board
Date/Time: Sat, 21 Dec 2024 18:25:28 +0000
Post From: time function
| [2014-12-02 13:58:11] |
| Sawtooth - Posts: 4141 |
|
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. |