What does ! mean in the formula?
 

What does the ! mean before a cell when transferring the cell contents to a
different page?

If it's in a string, it means it's a point of emphasis:

=if(a1=1,"Get too work!","Please, continue to work.")

if you see it a reference, it's excel's delimiter to separate the sheetname from
the address:

=sheet1!a1
or
='this is sheet 1"!a1

The formulas return the value from that sheet in cell A1.

Juanita wrote:

What does the ! mean before a cell when transferring the cell contents to a
different page?

--

Dave Peterson