Solver UDFs

  • Thread starter Thread starter immanuel
  • Start date Start date
I

immanuel

Are the UDFs exposed by the Solver addin able to be used
as worksheet
functions in XL2002? I'm trying the following:

A1: 10
A2: 20
A3: =SUM(A1:A2)
B1: =SOLVEROK(A3, 3, 50, A1)

It looks like we cannot solve using the UDFs. Just wanted
verification
before I try another vector.

/i.
 
SolverOK and the other functions are functions in the programmatic
sense. However, they do not adhere to the rules that UDFs must obey to
be used in as worksheet.

--
Regards,

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