Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
What does the "!" mean in the above formula?
|
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
It divides the sheet name from the cell reference.
-- David Biddulph "Cowboysupt" wrote in message ... What does the "!" mean in the above formula? |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Don't want the "All" option in the Drop Page Field of a pivot tabl | Excel Discussion (Misc queries) | |||
How do I generate and subtotal percentages of data in a pivot tabl | Excel Discussion (Misc queries) | |||
Can I do calculations on already calculated fields in a pivot tabl | Excel Discussion (Misc queries) | |||
How to use the contents of a cell for a data range in a pivot tabl | Excel Discussion (Misc queries) | |||
How do I just get a cell reference when referring to a pivot tabl. | Excel Discussion (Misc queries) |