Although Excel's relative reference approach makes it convenient for copying formulas across a row or a column, it could calculate incorrectly if one of the formula's cell coordinates needs to remain the same.
A good example from the LearnExcelNow on-demand workshop "Microsoft Excel: The Basics and Beyond for Today's Top…