You open a workbook to make a few enhancements. You enter a new formula and then copy it, but instead of displaying the expected results, the copied formulas display the result of the first formula.
Each formula in row 10 displays $7,806! What's going on?
Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.