To solve faulty results and values:

1. Click Tools > Goal Seek.

2. Enter required target cell and the cell that gives you a varying result and not the result you were expecting.

      3. Both the target and variant cells should be formula cells for Goal Seek to work.

      4. Click OK to arrive at the required value at the variant cell.

​