Login Page - Create Account

Support Board

Date/Time: Sun, 15 Dec 2019 05:49:35 +0000

[User Discussion] - =AND function

[2013-12-03 01:43:49]
User021827 - Posts: 174
I want to have a second criteria with the and function.

I use =AND(crossfrombelow(A3:A4,AA3:AA4),AA3:AA4>0)

1. how can I use > greater than in place of cross from below ?
2. how would I add the second criteria of lets say : AB3:AB4>20 adx is greater than 20

can I use numerical numbers like that or do I have to have them as data in a column ?


[2013-12-03 04:19:48]
vegasfoster - Posts: 444
Your crossfrombelow syntax is ok. That said, to replace it, you would use "=And(A3>AA3, A4<AA4)" or "=And(A3<AA3, A4>AA4)" depending on whether you want to crossfrombelow or crossfromabove.

The following syntax is not ok, "AA3:AA4>0". If you want the line represented in column AA to be above zero, then simply use AA3>0.
[2013-12-03 12:18:57]
User021827 - Posts: 174
I was using the syntax you mentioned is not ok. That is where my problem was.
Thank you for pointing that out ! I appreciate it.


To post a message in this thread, you need to login with your Sierra Chart account:


Login Page - Create Account