Support Board

Date/Time: Sun, 06 Jul 2025 03:55:01 +0000

Post From: SpreadSheet Formula for Close below then back above a level

[2020-01-22 20:13:44] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4235
Try something like this: =AND(E4<ID1.SG1@4,E3>ID1.SG1@3) where ID1 is a moving average. This also works: =CROSSFROMBELOW(E3:E4,ID1.SG1@3:ID1.SG1@4)