Formula for excel.

S

shy_girl_7_13_

Can anyone help me understand what this formula does. And what does the $
mean.
=+B12/$N$13

Thank you so much for your help.
 
P

PCLIVE

I don't think the "+" actually does anything. I believe that is left over
from Lotus 123. Anyway, the $ makes a constant reference of N13. This
means that if you copy and paste the formula to other cells, N13 remains the
reference. Without the $, the formula would be adjusted based on where you
paste the formula. For example, if your formula was in C1 and you copied
and pasted into C2, without the $, the formula would be adjusted to:

=+B13/N14

The row has increased by one.

HTH,
Paul
 
M

mightybaldking

shy_girl_7_13_ said:
Can anyone help me understand what this formula does. And what does the $
mean.
=+B12/$N$13

Thank you so much for your help.
Click to expand...

The + is irrelevant.

This takes the value in cell B12, divides it by the value in cell N13.

The $ have no effect on a single cell, but come into play when you
copy.

When you copy a cell reference down, the row is incremented by 1;
across, and the column is incremented to the next letter.

Example:
In cell B2, type "=a1"
Now copy it down a row, and it will become "=a2"
Copy this across 1 and it becomes equals "=b2"

Go back to cell B2, and change the formula to "=$a$1"
Copy it down and across all you like, and it will always stay "=$a$1"

The $ indicates 'absolute referencing'. You can think of it as "Lock
this row/column reference when I copy"
 
Top