Support Board

Date/Time: Thu, 25 Apr 2024 22:31:45 +0000

Post From: =AND function

[2013-12-03 04:19:48] Link To Thread - Link To Post [Go To First Post]
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.