simple syntax questions

[snaven]

Would someone please explain syntax & use of the character "$" and the character "!" in Excel formulas (not necessarily in the same formula)?

Thanks!

 

[VoG]

For $ see http://www.cpearson.com/excel/relative.aspx

For !

='My Sheet'!A1

defines the end of the text that defines a worksheet name.

 

[snaven]

Thanks, the Pearson site looks like a great resource.