[calc] is there a GOAL_SEEK function somewhere?

users
#1

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

#2

menu:Tools>Goal Seek ?

#3

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

#4

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?

#5

Some one else had a similar question:

https://forum.openoffice.org/en/forum/viewtopic.php?f=45&t=4331&start=0

I'm studying that to see if that will help.
However, apparently, the code in the above GSeek won't work in
libreoffice :frowning: