Solver UDFs

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.
 
T

Tushar Mehta

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Avoiding redundant calculations 7
Calculate end date and time 1
Creating a formula relating to several cells 2
Is there a single function that duplicates Solver? 1
Excel 2003 + Solver 3
How to get address of cell calling UDF? 2
Error with sum formula in excel 2007 4
Can these look ups be done using Worksheets functions 6

Top