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.
Full article: Avoiding keyed in values in Excel formulas
