08-19-2004, 09:34 AM
|
#1 |
|
Chief of Naval Operations
  
Join Date: Jun 2000
Location: woah... why is welfareloser here with me so early in the morning and more importantly why am I wearing her clothes?!?
Posts: 13,754
|
Question about equations in EXCEL
if a cell has the following equation what does it mean?
=B60/$B$61
__________________
********************************** DCM #1 (Founder)  "Nobody beats Vitus Gerulaitis 18 times in a row." - Vitus Gerulaitis on beating Jimmy Connors after 17 failed attempts. |
|
|
|
08-19-2004, 09:37 AM
|
#2 |
|
Admiral
 
Join Date: Feb 2001
Location: Maryland
Posts: 6,578
|
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, 09:44 AM
|
#3 |
|
Chief of Naval Operations
Join Date: Jun 2000
Location: woah... why is welfareloser here with me so early in the morning and more importantly why am I wearing her clothes?!?
Posts: 13,754
|
but what's with the $ sign? why not just =B60/B61?
OH NEVERMIND... IT'S AN ALWAYS KIND OF RULE EH? |
|
|
|
|
08-19-2004, 09:58 AM
|
#4 |
|
Admiral
Join Date: Feb 2001
Location: Maryland
Posts: 6,578
|
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 C1 =A1*B1 C2 =A2*B2 C3 =A3*B3 C4 =A4*B4 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 C1 =$A$1*B1 C2 =$A$1*B2 C3 =$A$1*B3 C4 =$A$1*B4 ... 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. Last edited by mcs328 : 08-19-2004 at 10:01 AM. |
|
|
|
|
08-19-2004, 10:05 AM
|
#5 |
|
captain awesome
Join Date: Jan 2003
Posts: 7,054
|
$ 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, 10:17 AM
|
#6 |
|
Chief of Naval Operations
Join Date: Jun 2000
Location: woah... why is welfareloser here with me so early in the morning and more importantly why am I wearing her clothes?!?
Posts: 13,754
|
nice thanks
|
|
|
|
Linear Mode
