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: [email protected]
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
