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
|