Support Board
Date/Time: Wed, 29 Oct 2025 04:18:41 +0000
Post From: Formula with one value but different condition
| [2013-08-25 14:31:30] |
| Sawtooth - Posts: 4281 |
|
To get a TRUE when the Williams %R crosses from below -80, or -50, or -2; or =0 try this: =OR(CROSSFROMBELOW(AA3:AA4,BA3:BA4),CROSSFROMBELOW(AA3:AA4,BB3:BB4),CROSSFROMBELOW(AA3:AA4,BC3:BC4),AA3=BD3) where AA is the Williams %R column. |