View Full Version : Question about equations in EXCEL
08-19-2004, 08:34 AM
if a cell has the following equation what does it mean?
08-19-2004, 08:37 AM
divide cell B60 with B61. If you were to copy that formula then you will always divide by B61 now matter where you copy and paste the formula too. It's a referenced cell.
08-19-2004, 08:44 AM
but what's with the $ sign? why not just =B60/B61?
OH NEVERMIND... IT'S AN ALWAYS KIND OF RULE EH?
08-19-2004, 08:58 AM
Ok poor explanation. Let's say you have a cell that's the tax rate of 0.05 in cell A1. You want to multiply everything in column B by the this tax rate and have the tax amount in column C. The formula in cell C1 would be = A1*B1. This works for cell C1 but if you were to copy this formula to C2 to C100 you would get
Cell | Formula
Instead of copying 0.05 in Column A all the way down, you would just reference A1 outright by using the $ sign. The formula in C1 would be = $A$1*B1. If you copy is down column C you would get
Cell | Formula
Was that better? Yeah and Always kind of rule. In your case it's always divide by cell B61. And in my case it would be always multiply by cell A1.
$ signifies a "sticky"
If the $ sign appears in front of the Column letter, then the formula will always reference that column. If the $ sign appears in front of the Row number, then the formula will always reference that row. If the $ signs appears in front of both the Column and Row, then the formula will always reference that cell.
08-19-2004, 09:17 AM
Powered by vBulletin® Version 4.1.12 Copyright © 2013 vBulletin Solutions, Inc. All rights reserved.