Avoiding keyed in values in Excel formulas

Avoiding keyed in values in Excel formulas

5 June 2019

One of the cardinal rules of Excel is don't key-in a value into a formula if that value could change.

Tracking the value down could be problematic if you need to change the value. Tables can be the solution to avoiding keyed-in values.