Support Board

Date/Time: Mon, 13 May 2024 06:04:27 +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: 3995
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.