Support Board
Date/Time: Sat, 21 Dec 2024 17:47:50 +0000
New Spreadsheet SC version 1278 #VALUE!
View Count: 801
| [2015-07-29 02:48:41] |
| User80177 - Posts: 29 |
|
Why is the first formula an error? Col W =AND(OR(CJ3<-25,CJ4<-25),AA3 = true)*D3 evaluates to #VALUE! Col AA3 =AND(CN3>CN4,CN4<CN5,CN5<CN6) evaluates to FALSE Col CJ3 = 0 from study Col CJ4 = 130.5 from study By the way, it would be useful to provide copy to clipboard from the Cell Detail window. Thanks |
| [2015-07-29 02:59:02] |
| |
|
This is not a valid: AND(OR(CJ3<-25,CJ4<-25),AA3 = true)*D3 Try this: IF(AND(OR(CJ3<-25,CJ4<-25),AA3 = TRUE),D3,0) We will see about this: By the way, it would be useful to provide copy to clipboard from the Cell Detail window. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to 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: