How to Use the IF Function in Excel 2007 With Absolute References. Cells in Excel are referred to using relative or absolute references. A formula with relative references changes when the cell's ...