what does the ! mark mean in an excel formula
 

We frown on questions entirely in the subject line and generally don't do
homework.

--
Don Guillett
SalesAid Software

"misslajones" wrote in message
...

Typically, it separates a sheet name from a cell reference. For
example, the formula

=A1

refers to cell A1 on the same sheet as the formula, while

=Sheet2!A1

refers to cell A1 on sheet2, regardless of the sheet on which the
formula resides.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"misslajones" wrote in
message
...