Reference a cell in an OR Formula

  • Thread starter Thread starter rhhince
  • Start date Start date
R

rhhince

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,T8610>75)
 
Just point at T$2:

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


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,T8610>75)
Click to expand...
 
=IF(OR(T8610<-T2,T8610>T2),"outside range","inside range")

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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,T8610>75)
|
 
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
 
do include the $ signs in T2

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| =IF(OR(T8610<-T2,T8610>T2),"outside range","inside range")
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
|| 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,T8610>75)
||
|
|
 
You could use something like this, too:

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

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

David said:
Replace < by > in your ABS() formulae, Dave, to meet the OP's requirement.
Click to expand...
 
Back
Top