Learn to use #excel Solver to find the best possible outcome under constraints
External Link : https://theexcelclub.com/use-solver-excel/
How to use Solver in Excel [Video]
Solver in Excel is part of the What if function. It's basic purpose is to find a solution that satisfies all the constraints and return the optimal result.
The Excel Club