Login Page - Create Account

Support Board


Date/Time: Fri, 29 Mar 2024 05:54:35 +0000



New Spreadsheet SC version 1278 #VALUE!

View Count: 725

[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]
Sierra Chart Engineering - Posts: 104368
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:

Login

Login Page - Create Account