Using the IF function with absolute references forces the cell reference inside a formula to remain constant. Open an Excel worksheet and add data to two columns, where the first column has one ...

Removing the dollar signs in these formulas converts absolute references to relative references, so the ranges can change when copied or moved. However, your Excel 2013 spreadsheet might also use ...

Cell references in Excel are like addresses that point to specific cells. Three types of Excel cell references are relative, ...

One of the best features in Excel is the ability to plug in a formula ... Watch to learn how to use the $ sign to lock in formulas. Produced by Daniel Goodman Read next BI Tech Memo Where Big ...