PDA

View Full Version : Question about equations in EXCEL

brainsmile
08-19-2004, 11:34 AM
if a cell has the following equation what does it mean?

=B60/\$B\$61

mcs328
08-19-2004, 11: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.

brainsmile
08-19-2004, 11:44 AM
but what's with the \$ sign? why not just =B60/B61?

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

mcs328
08-19-2004, 11: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
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
08-19-2004, 12:05 PM
\$ 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
08-19-2004, 12:17 PM
nice thanks