Support Board

Date/Time: Wed, 15 May 2024 23:59:02 +0000

Post From: Determining Slope or Direction. Cell Z3

[2018-04-28 21:11:21] Link To Thread - Link To Post [Go To First Post]
User324443 - Posts: 18
OK, I have pasted the “Slope” condition to Z3 and it returns a “1” for the whole column. I have the “Crossover” formula in K3 - =CROSSFROMBELOW(ID0.SG4@3:ID0.SG4@5,ID2.SG1@3:ID2.SG1@5) this works fine. However, as simple as it should be, I cannot add “=AND(Z4=-1,Z3=1)” and get anything but error messages. Obviously I am doing this incorrectly. Could I trouble you to show me how the CROSSFROMBELOW and the AND should be written as one formula. I have come a long, long way with this spreadsheet project but appear to be completely stymied at this last stage. All I need is the combined formula. I would prefer not to be sent on another hike round your manual and would be really appreciative if you could provide this final step and let me get to to trading which is what this is supposed to be about. Thank you for your attention in this matter.