Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
What does ! mean as an operator within a formula
I am copying formula which has an exclamation mark prefixing a cell reference
but I cannot determine what the operator calculates |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
What does ! mean as an operator within a formula
The ! separates the worksheet name from the cell reference. The more general
form: =[Book2]Sheet1!$A$1 The workbook name is inside the brackets, followed by the worksheet name, the !, then the cell address. "Tam" wrote: I am copying formula which has an exclamation mark prefixing a cell reference but I cannot determine what the operator calculates |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
What does ! mean as an operator within a formula
Hello Tam. An exclamation mark follows a worksheet name in formula. Example: =Sales!$G$20 Sincerely, Leith Ross -- Leith Ross ------------------------------------------------------------------------ Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465 View this thread: http://www.excelforum.com/showthread...hreadid=497254 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
What does ! mean as an operator within a formula
"bpeltzer" wrote: The ! separates the worksheet name from the cell reference. The more general form: =[Book2]Sheet1!$A$1 The workbook name is inside the brackets, followed by the worksheet name, the !, then the cell address. "Tam" wrote: I am copying formula which has an exclamation mark prefixing a cell reference but I cannot determine what the operator calculates |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Help with macro formula and variable | Excel Worksheet Functions |