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)
||
|
|