Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default ='Tabl.1&3 Cohorts'!C70

What does the "!" mean in the above formula?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 35,218
Default ='Tabl.1&3 Cohorts'!C70

It's the separator that excel uses between the worksheet name (Tabl.1&3 Cohorts)
and the address of the cell (C70).



Cowboysupt wrote:

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


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,651
Default ='Tabl.1&3 Cohorts'!C70

It divides the sheet name from the cell reference.
--
David Biddulph

"Cowboysupt" wrote in message
...
What does the "!" mean in the above formula?



  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 353
Default ='Tabl.1&3 Cohorts'!C70

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.

"Cowboysupt" wrote:

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

  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 15,768
Default ='Tabl.1&3 Cohorts'!C70

It identifies the text between the = sign and the ! as the sheet name.

Or, the sheet name identifier.

Biff

"Cowboysupt" wrote in message
...
What does the "!" mean in the above formula?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Don't want the "All" option in the Drop Page Field of a pivot tabl Vincerix Excel Discussion (Misc queries) 1 May 12th 06 09:22 PM
How do I generate and subtotal percentages of data in a pivot tabl Stan Sitek Excel Discussion (Misc queries) 1 March 15th 06 05:02 AM
Can I do calculations on already calculated fields in a pivot tabl Fen Excel Discussion (Misc queries) 3 January 5th 06 07:42 PM
How to use the contents of a cell for a data range in a pivot tabl bobs Excel Discussion (Misc queries) 0 August 2nd 05 07:31 PM
How do I just get a cell reference when referring to a pivot tabl. Aad Excel Discussion (Misc queries) 4 March 14th 05 03:51 PM


All times are GMT +1. The time now is 06:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"