6] The above steps will install the Data Analysis Tool on MS Excel. You can view it in the “Data” tab. Read: How to calculate the percentage difference between two numbers in Excel.

We can use Excel’s What-If calculator in this case. Go to the Data Tab —> What-If Analysis Menu —> Goal Seek to get to the What-If solver, plug in the numbers, and Excel will solve for the ...