Oops.

But that would have been obvious after a bit of testing--I guess you know that I
didn't test!

David Biddulph wrote:

Replace < by in your ABS() formulae, Dave, to meet the OP's requirement.
--
David Biddulph

"Dave Peterson" wrote in message
...
You could use something like this, too:

=(abs(t8610)<t$2)
or
=(abs(t8610)<abs(t$2))
to allow positive/negative numbers in T2.

Dave Peterson wrote:

Just point at T$2:

=OR(T8610<-T$2,T8610T$2)

rhhince wrote:

Does anyone know how to reference a cell number in an OR formula?
I am trying to replace the number 75 to reference a specific cell T$2
instead, so I can change the values in the column dynamically an save a
lot of steps. I somehow think the ampersand & could work, but I just
don't know how.

=OR(T8610<-75,T861075)

--

Dave Peterson

--

Dave Peterson

--

Dave Peterson