Thread: what does $ do in an xl formula
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default what does $ do in an xl formula
Those $ signs tell excel not to change that address if you copy that formula to
other cells.

Look in excel's help for "absolute references"

notsure wrote:

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

--

Dave Peterson
Reply With QuoteReply With Quote