software

I am copying formula which has an exclamation mark prefixing a cell reference
but I cannot determine what the operator calculates

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.

quot;Tamquot; wrote:

gt; I am copying formula which has an exclamation mark prefixing a cell reference
gt; but I cannot determine what the operator calculates


Hello Tam.

An exclamation mark follows a worksheet name in formula.

Example:
=Sales!$G$20

Sincerely,
Leith Ross--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: www.excelforum.com/member.php...oamp;userid=18465
View this thread: www.excelforum.com/showthread...hreadid=497254

quot;bpeltzerquot; wrote:

gt; The ! separates the worksheet name from the cell reference. The more general
gt; form:
gt; =[Book2]Sheet1!$A$1
gt; The workbook name is inside the brackets, followed by the worksheet name,
gt; the !, then the cell address.
gt;
gt; quot;Tamquot; wrote:
gt;
gt; gt; I am copying formula which has an exclamation mark prefixing a cell reference
gt; gt; but I cannot determine what the operator calculates