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?