Support Board

Date/Time: Mon, 01 Sep 2025 13:24:54 +0000

Post From: Lock a One Time Value in a spreadsheet

[2015-08-06 21:21:12] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4261
Here's a general example of an MA cross up setting a value, and an MA cross down setting another value: =IF(CROSSFROMBELOW(AQ3:AQ4,AR3:AR4),E3,IF(CROSSFROMABOVE(AQ3:AQ4,AR3:AR4),C3,S4)) where this formula is in cell S3. This will repeat the value until the MA crosses in the opposite direction. Substitute the CROSSFROMBELOW/ABOVE condition for your condition.