Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / April 2007

Tip: Looking for answers? Try searching our database.

='Tabl.1&3 Cohorts'!C70

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Cowboysupt - 30 Apr 2007 20:52 GMT
What does the "!" mean in the above formula?
Dave Peterson - 30 Apr 2007 21:00 GMT
It's the separator that excel uses between the worksheet name (Tabl.1&3 Cohorts)
and the address of the cell (C70).

> What does the "!" mean in the above formula?

Signature

Dave Peterson

David Biddulph - 30 Apr 2007 21:02 GMT
It divides the sheet name from the cell reference.
Signature

David Biddulph

> What does the "!" mean in the above formula?
BoniM - 30 Apr 2007 21:06 GMT
A 3-D cell reference includes the worksheet name, an exclamation point (!),
and the cell or cells referenced. The exclamation point is just the symbol
used as a seperator between the worksheet name and the cell address.

> What does the "!" mean in the above formula?
T. Valko - 30 Apr 2007 21:12 GMT
It identifies the text between the = sign and the ! as the sheet name.

Or, the sheet name identifier.

Biff

> What does the "!" mean in the above formula?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.