Support Board

Date/Time: Wed, 15 May 2024 14:21:34 +0000

Post From: Determining Slope or Direction. Cell Z3

[2018-04-28 21:33:48] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 3997
I am not SC Support. I am just a user. OK, I have pasted the “Slope” condition to Z3 and it returns a “1” for the whole column. The formula from the SC site will return a 1 for up slopes, and a -1 for down slopes. Maybe you've not edited it to reference ID2 instead of ID1. There are 12 ID1s that all need to be changed to ID2s. This assumes your ID2 is a moving average where there is only one subgraph of SG1. Once you've verified the Z3 formula, try this: =AND(CROSSFROMBELOW(ID0.SG4@3:ID0.SG4@5,ID2.SG1@3:ID2.SG1@5),Z4=-1,Z3=1) I would prefer not to be sent on another hike round your manual Don't be afraid of the documentation. It may seem daunting but it is comprehensive and will answer most questions.