Excel Advanced Tip: Tell your formulas how to behave with absolute references in formulas using '$'

Washington Dept. of Commerce

Aug 31, 2021

In Excel, if you write a formula in a cell, it is common for it to contain a cell reference, which means the formula points to a value in one or more other cells. In the example be…