[Libreoffice-bugs] [Bug 116514] yield function doesn't accept ref as 1st arg

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=116514

--- Comment #2 from Larry <cppljevans at gmail.com> ---
After changing the 1st arg to yield to directly reference the data cell,
it worked.  IOW:

=YIELD(B10,B11,B9,B15,100,B12,B2)

returned 8%.

I could have sworn I'd tried that before and got some error msg,
but maybe that was before I changed the format of the B10 and B11
cells to date or something.

Sorry for noise, but I would strongly suggest providing more
helpful error msg than #VALUE!.  It's very confusing when
a literal date value, "01/01/2000", works, but a reference
to the same value in a cell doesn't.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180320/53bb33ca/attachment.html>