Support Board
Date/Time: Sat, 15 Nov 2025 13:06:22 +0000
Post From: Formula Alerts error
| [2025-11-14 19:35:48] |
| User431178 - Posts: 811 |
|
Because when I wrote this formula I’ve got error but I really don’t understand what’s wrong. I hope the support can reply
If you look at the linked example you will understand better. And, like I said, the nesting of your formula is wrong. Here is corrected version. =OR(AND(ABS(AV[-1]-BV[-1])>=2000,C[-1]<O[-1],C>O,H>H[-1],ABS(AV-BV)<=400),AND(ABS(AV[-1]-BV[-1])>=2000,C[-1]>O[-1],C<O,L<L[-1],ABS(AV-BV)<=400)) Here are some direct links to understand how to apply AND and OR functions. https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#AND_Function https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#OR_Function |