Thread: What is this formula for?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
  
Posts: 2,202
Default What is this formula for?
Can someone explain this formula to me?
=$C$36/$B$6

The dollar signs represent absolute references; so the formula is dividing
whatever is in cell C36 by whatever is in cell B6... and will always do
that, no matter where you copy the formula to.

Rick

Reply With QuoteReply With Quote