Question about equations in EXCEL

[brainsmile]

if a cell has the following equation what does it mean?

=B60/$B$61

[mcs328]

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.

[brainsmile]

but what's with the $ sign? why not just =B60/B61?

OH NEVERMIND... IT'S AN ALWAYS KIND OF RULE EH?

[mcs328]

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.

[ray]

$ 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.

[brainsmile]

nice thanks