19 June 2013
Know some thing about dollor sign?why to use?
1)The absolute sign($), is used specially when you write an equation or any other thing in excel, and you want to copy it into other cells.
2)If you write "=E3+F3" in a cell, that cell will show the addition of E3 and F3. If you copy and paste to the cell below that, the equation will automatically change into "=E4+F4", also, if you copy that into the cell to the right of the first one, equation will change into "=F3+G3".
3)The absolute sign ($), avoids that, if you right that before the row or column (e.g. F$3 or $F3 or $F$3) the row, or column, or both, won't change when you copy and paste the equation.
Note: refer rules 1,2,3, as i said iin previous reply for ur reference
Note: it will be great help in sumif,vlookup,and many function while dong reconciliaiton and caluculations to give true results
CAclubindia
