ExcelBanter - Dollar Sign

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Dollar Sign (https://www.excelbanter.com/excel-discussion-misc-queries/69754-dollar-sign.html)

merleinkal

Dollar Sign

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

Fred Smith

Dollar Sign

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" wrote in message
...
In the formula J$4/50, what does the $ mean?

All times are GMT +1. The time now is 07:17 PM.