ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   What do these characters mean? (https://www.excelbanter.com/excel-programming/310603-re-what-do-these-characters-mean.html)

Frank Kabel

What do these characters mean?
 
Hi
the dollar signs indicate an absolute reference. See:
http://www.cpearson.com/excel/relative.htm

--
Regards
Frank Kabel
Frankfurt, Germany


simsjr wrote:
Ok, I get the following cell formula when I paste a link to a cell in
another tab. It looks like this:

='Example Tab'!$L$8

What I'd like to know is what the exclamation point and dollar signs
mean. Why can't Excel just do something like this instead?

='Example Tab'L8

Can anyone help?




All times are GMT +1. The time now is 04:43 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com