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