ExcelBanter - What does the $ infront of a cell indicate in a calculation mean?

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

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

- - What does the $ infront of a cell indicate in a calculation mean? (https://www.excelbanter.com/excel-discussion-misc-queries/157707-what-does-%24-infront-cell-indicate-calculation-mean.html)

kb556617sm

What does the $ infront of a cell indicate in a calculation mean?

What does the $ infront of a cell indicate in a calculation mean?

Jim Thomlinson

What does the $ infront of a cell indicate in a calculation mean?

The $ indicates that the cell is absolute referenced. If you drag that
formula the row or column will not increment as the formula is dragged. For
more info look up Absolute reference in help...
--
HTH...

Jim Thomlinson

"kb556617sm" wrote:

What does the $ infront of a cell indicate in a calculation mean?

All times are GMT +1. The time now is 03:44 AM.