$ in cell reference?
Hi,
The $ means "static value." This is often use in formulas to make cells,
rows or columns stay static when duplicating them in different areas of the
spreadsheet. For instance if you grab cell A$3 and turn it into A3 and
duplicate the formula to the right the formula will look something like this:
B$3.
Hope this helps!
Vicente
"Fredrated" wrote:
Pardon me if this is a stupid question, I am an access programmer
manipulating an excel spreadsheet with the object model.
What is the function of the $ in the following cell entry?:
=AVERAGE(S$3:S$33)
Thanks for any help.
Fred
|