Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for excel.
Can anyone help me understand what this formula does. And what does the $
mean. =+B12/$N$13 Thank you so much for your help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for excel.
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 "shy_girl_7_13_" wrote in message ... Can anyone help me understand what this formula does. And what does the $ mean. =+B12/$N$13 Thank you so much for your help. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for excel.
shy_girl_7_13_ wrote: Can anyone help me understand what this formula does. And what does the $ mean. =+B12/$N$13 Thank you so much for your help. 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" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |