NLSOLVE is a powerful spreadsheet solver function based on the Levenberg-Marquardt algorithm which is suitable for:
Finding roots of nonlinear equations.
Computing exact or best (least-square-error) solution to a system of coupled equations including systems with mixed equations and inequalities constraints.
Solving least squares best curve fitting problems.
Solving parametrized optimization problems in conjunction with other calculus functions.