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 ...