Support Board

Date/Time: Sun, 22 Dec 2024 11:26:18 +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: 4141
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.