Support Board
Date/Time: Sat, 23 Nov 2024 02:07:09 +0000
[Programming Help] - Spreadsheet Study: GetCorrespondingMatch help. #NUM!
View Count: 90
| [2024-09-24 23:12:11] |
| C_Money - Posts: 64 |
|
Hello! In my spreadsheet study. I am trying to find the first instance of a 2 or a 3 from O3 to P1000. I just want the most recent value in either column. If true, then I want the following IF(AND statement to be evaluated: =IF(OR(
GetCorrespondingMatch(O3:P1000, 2, 0, 0, 0, O3:P1000, 0), GetCorrespondingMatch(O3:P1000, 3, 0, 0, 0, O3:P1000, 0) ), IF(AND( ID0.SG4@3 > (ID41.SG1@3 - 2), ID0.SG4@3 > ID43.SG1@3, ID0.SG4@3 > (ID42.SG1@3 - 3), CROSSFROMBELOW(ID10.SG1@3:ID10.SG1@4, ID10.SG6@3:ID10.SG6@4) ), ID0.SG3@3 - 3, 0), 0) Unfortunately this is throwing a #NUM! error in every cell all the way down column AC where I have the formula entered. |
| [2024-09-25 13:31:42] |
| John - SC Support - Posts: 36238 |
|
Look at the "Details" of the formula by selecting the "Details" button on the right of the formula line. This will point you to where the particular problem is. Refer to the following: Working with Spreadsheets: Viewing Formula Expression Tree For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
To post a message in this thread, you need to log in with your Sierra Chart account: