This is often done using the goal seek function in Microsoft Excel or what-if analysis via computer programs. Goal-seek software only works if there’s only one input value, however.

Enter Goal Seek and the Solver add-in, two tools that let Excel do the heavy lifting when it comes to finding those unknowns. When you have a formula in Excel but need to find the value of one ...