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
 

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
Solver Compiler issue 2
Is there a single function that duplicates Solver? 1
Spreadsheet question 5
Help Creating Excel Formula 4
Scrabble Value calculation for Welsh words 0
Error with sum formula in excel 2007 4
Creating a formula relating to several cells 2

Back
Top