is there anyway to call the Solver add-in as a function?
 

No.

A function can only return a value to be shown in the cell(s) in which
it is entered. Solver works by changing various worksheet cells as it
deems fit to find an optimal solution. That makes it impossible to use
Solver as a function.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
I would like to call the Solver add-in as a function from a cell and feed it
the input parameters on the main Solver dialog box. Is there a way to do this?