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)

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

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

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

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

=IF(OR(T8610<-T2,T8610T2),"outside range","inside range")

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"rhhince" wrote in message ps.com...
| 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)
|

do include the $ signs in T2

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Niek Otten" wrote in message ...
| =IF(OR(T8610<-T2,T8610T2),"outside range","inside range")
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
| "rhhince" wrote in message ps.com...
|| 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)
||
|
|

Please, try to expand the question.
If a cell has a value of 75 (or if ABS(cell value) 75 ) what cell do you
want to alter?
You will need a macro to change the ***same*** cell.
best wsihes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"rhhince" wrote in message
ps.com...
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)