View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
Luke M[_4_] Luke M[_4_] is offline
external usenet poster
 
Posts: 457
Default Functions for dummies

....and the "!" is used to seperate the Sheet name from the cell reference.

--
Best Regards,

Luke M
"Gordon" wrote in message
...

"gamegirl" wrote in message
...
What does the $ & ! mean in a formula?


"$" means that the reference is absolute, i.e. it won't change when you
copy or drag the formula.