='Tabl.1&3 Cohorts'!C70
 

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

='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

='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?

='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?

='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?