View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Reference a cell in an OR Formula

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