T
Tam
I am copying formula which has an exclamation mark prefixing a cell reference
but I cannot determine what the operator calculates
but I cannot determine what the operator calculates
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
bpeltzer
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.
form:
=[Book2]Sheet1!$A$1
The workbook name is inside the brackets, followed by the worksheet name,
the !, then the cell address.
L
Leith Ross
Hello Tam.
An exclamation mark follows a worksheet name in formula.
Example:
=Sales!$G$20
Sincerely,
Leith Ross
An exclamation mark follows a worksheet name in formula.
Example:
=Sales!$G$20
Sincerely,
Leith Ross
T
Tam
bpeltzer said: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 said:I am copying formula which has an exclamation mark prefixing a cell reference
but I cannot determine what the operator calculates