what does $ do in an xl formula

  • Thread starter Thread starter notsure
  • Start date Start date
N

notsure

I HAVE A cell WITH A FORMULA =+D40/$O$2 Can someone tell me what the $ does?
 
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"
 
The $ basically locks down the column or row after it - so, in your example
below the $ locks column O and row 2 - if you were to copy the formula down
one row it would look at D41 (instead of D40) but it would still look at O2
because that has been locked....
Hope that makes sense!!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If function help 6
combining formulas 1
Subtracting based on 2 conditions 3
MATCH w/ multiple answers? 8
Move text 1
Excel 2
Filling speadsheet with INDIRECT functions? 2
Scrabble Value calculation for Welsh words 0

Back
Top