| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
$
What does the dollar sign do in excel?
-- Brian |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
$
One usage is an absolute reference. The formula =A! when copied to a
different cell may change to =B1 or =A2. The formula =$A$1 will not change when copied. -- Gary's Student "brianwakin" wrote: What does the dollar sign do in excel? -- Brian |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
$
What about when a $ sign is used after a function name such as LEFT$?
"Gary's Student" wrote: One usage is an absolute reference. The formula =A! when copied to a different cell may change to =B1 or =A2. The formula =$A$1 will not change when copied. -- Gary's Student "brianwakin" wrote: What does the dollar sign do in excel? -- Brian |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
$
crazybass2 wrote:
What about when a $ sign is used after a function name such as LEFT$? You avoid converting the string to a Variant. See http://www.dicks-blog.com/archives/2...on-efficiency/ -- Dick Kusleika Excel MVP Daily Dose of Excel www.dicks-blog.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
