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: Logo

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

Facebook photo

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

Connecting to %s