Support Board
Date/Time: Sat, 23 Nov 2024 23:42:44 +0000
Post From: Formula with one value but different condition
| [2013-08-25 14:31:30] |
| Sawtooth - Posts: 4118 |
|
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. |