Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Sat, 27 Apr 2024 14:01:11 +0000

How to Post a Message for Support

Post From: Formula with one value but different condition

[2013-08-25 14:31:30]
[Go To First Post]
Sawtooth - Posts: 3977
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.