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