Support Board
Date/Time: Sun, 22 Dec 2024 21:23:25 +0000
Post From: Spreadsheet
| [2015-01-23 14:17:48] |
| User43824 - Posts: 9 |
|
Hi SC support team, I am trying to find out how your spreadsheet works but I have difficulties. According your manual (http://www.sierrachart.com/index.php?page=doc/doc_SystemsAlerts.php ) I put =AND(CROSSFROMBELOW(E3:E4,AA3:AA4),$J$8=0) in cell K3. I received some TRUE results. Super. But when I put a simple formula =OR(AND($J$8>0,E3<=$J$9-1),AND($J$8>0,E3>=$J$9+2)) in cell L3 I did not receive any TRUE results, only FALSE. Settings: Order Quantity (read/write) – cell J26: 1 Can you let me know where the problem is? Thank you. |