Support Board
Date/Time: Sun, 24 Nov 2024 21:53:49 +0000
Post From: =AND function
| [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. |