https://bugs.documentfoundation.org/show_bug.cgi?id=116514
--- Comment #2 from Larry <[email protected]> ---
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.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
