dollar sign

  • Thread starter Thread starter Jules
  • Start date Start date
this means absolute cell addres. if you use this in any formula etc it will
always be B3 only.
 
It differentiates between absolute and relative referencing, and becomes
important when using a formula over many cells.

As an example, enter =$B$3 in A1, and enter =$B3 in B1. Then select A1:B1
and copy them, and then paste to A2:B2. In A2, you should see =$B$3, exactly
in A1. But in B2 you should see =$B4, which means that the formula has
changed relative to the cell it is placed in.
 
It means that it "Fixes" a cell location. e.g. if you have a list of numbers
in column E
if you do E3*$B$4 and copy the formula down in column E... it will
always multiply column E's nunbers by by cell B4
 

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

Are password protected WiFi networks secure? 3
The letter "b" appears after the dollar sign 7
Copying a formula while leaving one cell fixed 1
Need help with formating cell 3
Formatting Currency Without Any Special Characters 3
what is the difference !!! 3
Dollar signs on all tabs 4
Concatenate & Number Formats 2

Back
Top