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

On 01/26/2016 08:42 AM, Larry Evans wrote:
> 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

I want something along the lines of:

Sub GSeek()
    With Worksheets("Sheet1")
        .Range("H18").GoalSeek _
        Goal:=.Range("H32").Value, _
        ChangingCell:=.Range("G18")
    End With
End Sub

shown here:

http://stackoverflow.com/questions/18139322/goal-seek-macro-with-goal-as-a-formula

Would that code work in libreoffice?





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