Guys,

I have a spreadsheet with many calculations. I need to maximize my equation with some restrictions. As my equation is not linear, I'm using evolutionary option in solver. It finds me a solution, but it's not the best (maximal value). Is there any secret how solver can find the best solution, actually?