#1   Report Post  
Jules
 
Posts: n/a
Default dollar sign

What does the dollar sign mean in a formula, for example what does $B$3
mean?
Cheers


  #2   Report Post  
R.VENKATARAMAN
 
Posts: n/a
Default

this means absolute cell addres. if you use this in any formula etc it will
always be B3 only.


Jules wrote in message
...
What does the dollar sign mean in a formula, for example what does $B$3
mean?
Cheers




  #3   Report Post  
Bob Phillips
 
Posts: n/a
Default

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.

--
HTH

Bob Phillips

"Jules" wrote in message
...
What does the dollar sign mean in a formula, for example what does $B$3
mean?
Cheers




  #4   Report Post  
Phil Wales
 
Posts: n/a
Default

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




"Jules" wrote:

What does the dollar sign mean in a formula, for example what does $B$3
mean?
Cheers



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do you sign up for courses at Office Online? corin Excel Discussion (Misc queries) 1 April 19th 05 11:04 PM
Changing Dollar sign to another currency not listed in Excel Rehan Excel Discussion (Misc queries) 1 April 12th 05 04:03 PM
Align $ sign next to numbers Christina Excel Discussion (Misc queries) 5 April 7th 05 07:21 PM
Show = sign Nicole Excel Discussion (Misc queries) 2 March 27th 05 05:05 PM
Dollar Bill Chart RJB1 Charts and Charting in Excel 2 January 7th 05 03:51 PM


All times are GMT +1. The time now is 04:37 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"