Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sun, 12 May 2024 16:53:58 +0000
Post From: Spreadsheet Formula Help
| [2020-05-21 07:13:54] |
| User486817 - Posts: 81 |
|
Hello, I'm new to formula creation and would like to create a formula with the following three conditions: (ID6.SG1 <=-40) AND((ID6.SG1[0] > ID6.SG1[-1]) , (ID6.SG1[-1] <= ID6.SG1[-2])) (ID17.SG8 [0] > ID17.SG8[-1]) I have input the following into the spreadsheet and no matter how i correct it, it returns a syntax error: =AND((ID6.SG1 <=-40), AND((ID6.SG1[0] > ID6.SG1[-1]) , (ID6.SG1[-1] <= ID6.SG1[-2])) , (ID17.SG8 [0] > SG8[-1])) If it is possible for someone to help, thank you so much for your kindness. best regards, Date Time Of Last Edit: 2020-05-21 07:17:33
|