256 Kilobytes

Answers in Spreadsheets | By Some Guy

Published

498 views, 0 RAMs, and 2 comments

Tags: Google Sheets, Spreadsheets, Google

Profile Photo - Some GuySome GuyBasic Subscriber

I'm an accountant and we've switched over to using Google Sheets instead of Excel and I'm trying to figure out of the dollar signs mean the same thing in Google Sheets or if they do something else.

Download more RAM. 🐏 ⨉ 0Posted by Some Guy 2 years ago 🕓 Posted at 06 February, 2019 14:35 PM PST

This is a debug account.

Profile Photo - WTCMolybdenam4753WTCMolybdenam4753256KB WriterMcallen, TX

After searching on the internet, I found this helpful link which seems to explain in detail about the Dollar Sign in Google sheets. Here is the link:

https://support.knewton.com/faq-library/using-statistical-software-with-knewton/cell-references-and-using-the-dollar-sign

Hope this helps.

Download more RAM. 🐏 ⨉ 0Posted by WTCMolybdenam4753 2 years ago 🕓 Posted at 30 March, 2019 14:03 PM PDT
Profile Photo - UnivaUnivaAuthor

The $ is used in a cell reference to create an absolute reference. An absolute reference is one that will not change when the formula is copied.

There are many variations of absolute references:

  • $A$1 Formulawill always point to column A and row 1
  • $A1 Formula will always point to column A, but the row is allowed to change as the formula is copied

And so and so.....

Download more RAM. 🐏 ⨉ 0Posted by Univa 1 year ago 🕓 Posted at 31 May, 2019 10:47 AM PDT

Hello.

Post a New Comment

Do you like having a good time?

Register an Account

You can also login to an existing account or reset your password. All use of this site is subject to the terms of service and privacy policy.

Read Quality Articles

Read some quality articles. If you can manage to not get banned for like five minutes, you can even post your own articles.

View Articles →

Argue with People on the Internet

Use your account to explain why people are wrong on the Internet forum.

View Forum →

Vandalize the Wiki

Or don't. I'm not your dad.

View Wiki →

Ask and/or Answer Questions

If someone asks a terrible question, post a LMGTFY link.

View Answers →

Make Some Money

Hire freelancers and/or advertise your goods and/or services. Hire people directly. We're not a middleman or your dad. Manage your own business transactions.

Register an Account

Answers— Read More

Find more related content below!