Dollar Sign

In the formula J$4/50, what does the $ mean?

It's an absolute (as opposed to relative) reference. When you copy the formula
to another cell, row 50 will not change. Column J would change if you copied it
to a different column.

--
Regards,
Fred


"merleinkal" <merleinkal@discussions.microsoft.com> wrote in message
news:5FC3BD74-EB21-4DE9-B53F-048C442BF485@microsoft.com...
> In the formula J$4/50, what does the $ mean?