Wednesday, April 22, 2009

Fixed Parameter in Excel

If you want to use fixed parameter in formula in Excel then add '$' before and after the cell name. For example, in this screen shot you want the first parameter under column C is always A1, i.e. the first row of column A. Hence, the formula should be $A1$. When you copy the formula to other cells, the first parameter will always be A1, not An where n is the row number.

No comments: