We can use Solver in MS Excel to do a multiple variable analysis quickly and easily. You can display a variety of results like maximum, minimum and exact value in the target or result cell. The result cell’s value can also be made dependent on a variety of limitations or constraints like quantity of raw materials, etc.
Solver is also known as the tool for ‘optimization and equation solving’.
Solver does a what if analysis using multiple variables.