What does the "!" mean in the above formula?
D Dave Peterson Apr 30, 2007 #2 It's the separator that excel uses between the worksheet name (Tabl.1&3 Cohorts) and the address of the cell (C70).
It's the separator that excel uses between the worksheet name (Tabl.1&3 Cohorts) and the address of the cell (C70).
B BoniM Apr 30, 2007 #4 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.
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.
T T. Valko Apr 30, 2007 #5 It identifies the text between the = sign and the ! as the sheet name. Or, the sheet name identifier. Biff
It identifies the text between the = sign and the ! as the sheet name. Or, the sheet name identifier. Biff