[libreoffice-users] Re: [calc] is there a GOAL_SEEK function somewhere?

On 01/26/2016 07:18 AM, Andreas Säger wrote:
> Am 26.01.2016 um 11:47 schrieb Larry Evans:
> > I've checked that the value returned by the YIELD function:
> >
> > https://help.libreoffice.org/Calc/Financial_Functions_Part_Two#YIELD
> >
> > can be gotten by using [Tools>Goal Seek...] and the PV function:
> >
> > https://help.libreoffice.org/Calc/Financial_Functions_Part_One#PV
> >
> > Is there some way I could use a something like a GOAL_SEEK function
> > to implement my own version of YIELD?  IOW, without having to go
> > through the answering of the [Goal Seek] dialog window requesting
> > Formual cell, Target Value, and Variable cell?
> >
> > TIA.
> >
> > -regards,
> > Larry
>
> menu:Tools>Goal Seek ?
As mentioned in my message, I've used that from the UI.
What I want is to call some function, GOAL_SEEK, from within
a macro.  Sorry I wasn't clearer.  I'm guessing
YIELD *must* be implemented using some such function, and
I was hoping a macro could somehow get access to that function
even though there's no GOAL_SEEK function in the published
set of functions.

Hope that's clearer.

-regards,
Larry



-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted