Issues Caused by Hard-Coding Values in Excel Formulas . Let's say you're working out the cost of products in your store when a 20% tax is added.