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

However, some people are less familiar with a special type of reference that comes with these tables: structured references.