Hi Andrew,
This link is about OOo 1.1 and IRR - not about OOo 2 - but it might help with the problem... http://www.oooforum.org/forum/viewtopic.php?p=23389 I think if you keep following the links it gets to some interesting code but not in StarBasic or VBA. Rob Winchester ... > Using IRR, I can see that I have a 1% yield between each equally spaced > investment. > Using XIRR, I can see a 12.7199% effective yield overall. Fabulous. > > Of course, what I really want is: > > Date Amount Value IRR XIRR > 01/01/04 -100.0000 100.00 0.00% 12.72% > 02/01/04 -100.0000 202.00 2.00% 26.26% > 03/01/04 -100.0000 303.01 1.00% 13.02% > 04/01/04 306.0401 000.00 1.00% 12.72% > > This would be easy if IRR and XIRR allowed each range to be specified as > ($B$2:B4;C4). Although this works for SUM and a few others, it does not > work for IRR (this has been discussed before). Is there another solution > for this? > > I was under the impression that this might be changed for OOo version 2.0. > http://www.openoffice.org/issues/show_bug.cgi?id=32341 > > I think that I will vote for this issue! > ===== Rob Winchester Download OpenOffice today! __________________________________ Do you Yahoo!? Yahoo! Mail - Helps protect you from nasty viruses. http://promotions.yahoo.com/new_mail --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]