If you know the result you want but not the input value that produces it, use Goal Seek: Data → What-If Analysis → Goal Seek.
- Set cell — the cell with the formula (the result);
- To value — the desired result;
- By changing cell — the input cell (no formula!).
Example from the manual: the PMT formula gives a payment higher than you can afford. Goal Seek finds the loan term that makes the payment affordable.
Excel finds the value by iteration, so the result may be fractional — round it.