Support Board
Date/Time: Fri, 31 Oct 2025 00:37:25 +0000
[User Discussion] - =AND function
View Count: 1432
| [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 ? thanks |
| [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 |
|
thanks 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. shane |
To post a message in this thread, you need to log in with your Sierra Chart account: