Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
YAI YAI is offline
external usenet poster
 
Posts: 1
Default Use of $ symbol while writing a formula?


  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,311
Default Use of $ symbol while writing a formula?

$ makes your reference constant. For example, if in A1 you have =B1 and
then you copy cell A1 and paste it in A2, your formula will automatically
incriment, therefore being =B2.
In order to make what you paste refer to the same reference, your formula
would have to be =$B1. A $ before the B will maintain your column reference
as "B" regardless of where you copy and paste the formula to. To also
maintain the row reference, you would need a $ next to the number as well.
Ex. =$B$1

You should be able to find help topics in Excel for this.

HTH,
Paul


"YAI" wrote in message
...



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 37
Default Use of $ symbol while writing a formula?

if you copy this
=$A$1
down you will find each cell still points to A1
The $ fixes the part of cell reference following


"YAI" wrote in message
...




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
Reusing formula Tony29 Excel Discussion (Misc queries) 7 September 7th 06 03:34 AM
NEED HELP in Writing a FORMULA in colum D Soth Excel Worksheet Functions 4 July 5th 06 09:00 PM
Trouble writing an excel formula. hbb2699 Excel Worksheet Functions 3 June 8th 06 06:36 PM
Help writing a lookup formula kgoldner Excel Worksheet Functions 1 January 13th 06 06:12 PM
writing a formula for a colored value aaronwexler New Users to Excel 11 September 1st 05 03:11 PM


All times are GMT +1. The time now is 04:20 AM.

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"