Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Use of $ symbol while writing a formula?
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
NEED HELP in Writing a FORMULA in colum D | Excel Worksheet Functions | |||
Trouble writing an excel formula. | Excel Worksheet Functions | |||
Help writing a lookup formula | Excel Worksheet Functions | |||
writing a formula for a colored value | New Users to Excel |