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