Support Board
Date/Time: Fri, 07 Feb 2025 07:05:03 +0000
Post From: Spreadsheet Formula Help
| [2020-05-21 11:55:24] |
| Sawtooth - Posts: 4173 |
|
If you are using the Spreadsheet Formula study, your formula should work: =AND((ID6.SG1 <=-40), AND((ID6.SG1[0] > ID6.SG1[-1]) , (ID6.SG1[-1] <= ID6.SG1[-2])) , (ID17.SG8 [0] > ID17.SG8[-1])) If you are using a spreadsheet study, the syntax is different: =AND((ID6.SG1@3 <=-40) , AND((ID6.SG1@3 > ID6.SG1@4) , (ID6.SG1@4 <= ID6.SG1@5)) ,(ID17.SG8@3 > ID17.SG8@4)) It could be simplified: =AND(ID6.SG1@3 <=-40 , ID6.SG1@3 > ID6.SG1@4 , ID6.SG1@4 <= ID6.SG1@5 , ID17.SG8@3 > ID17.SG8@4) Working with Spreadsheets: References to Study Subgraph Columns when using the Spreadsheet Study |