Using the $ signs in an Excel Formula or Function for Absolute and Mixed Referencing

If you have seen the $ signs used in an Excel formula or function you might have wondered what they are for. You might also have been looking for something that stops cells or ranges in formulas or functions from changing. What we are looking at here is using absolute referencing instead of relative referencing. If you are using a combination of the two it is called mixed referencing.

See this video tutorial to see how to use the $ signs.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s