View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John C[_2_] John C[_2_] is offline
external usenet poster
 
Posts: 1,358
Default what does $ do in an xl formula

Read your help file on relative reference and absolute reference.
--
John C


"notsure" wrote:

I HAVE A cell WITH A FORMULA =+D40/$O$2 Can someone tell me what the $ does?