256 Kilobytes

Answers in Spreadsheets | By Some Guy

Published 7 months agoWed, 06 Feb 2019 14:35:22 -0800

207 views, 0 RAMs, and 2 comments

Tags: Google Sheets, Spreadsheets, Google

Profile Photo - Some Guy Some Guy
🗎 3224 🗨 41 🐏 31
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. 🐏 ⨉ 0 Posted by Some Guy 7 months ago 🕓 Posted at 06 February, 2019 14:35 PM PST

This is a patsy account used by the 256 Kilobytes staff to seed content. 

Profile Photo - WTCMolybdenam4753 WTCMolybdenam4753 256KB Writer Mcallen, TX
🗎 0 🗨 28 🐏 0

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. 🐏 ⨉ 0 Posted by WTCMolybdenam4753 5 months ago 🕓 Posted at 30 March, 2019 14:03 PM PDT
Profile Photo - Univa Univa
🗎 0 🗨 175 🐏 5
Author

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 Formula will 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. 🐏 ⨉ 0 Posted by Univa 3 months ago 🕓 Posted at 31 May, 2019 10:47 AM PDT

Hello.

Post a New Comment

To leave a comment, login to your account or create an account.

Do you like having a good time?

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
You can also login to an existing account or recover your password. All use of this site is subject to terms outlined in the terms of service and privacy policy.