See other exemple attached. Financial Calculation for "i" with following data: nper = 1000; pv = -2000; fv = 0; pmt = 600; type = 1 and other with type = 0; estimation = 0% and estimation = 100%.
> Date: Fri, 28 Aug 2009 16:14:48 +0000 > From: fernando_sto...@hotmail.com > To: fernando_sto...@hotmail.com > Subject: [Bug 420614] [NEW] Bug on OpenOffice Calc Financial Calculator > Formulas gives wrong value to Interest Rate Calc > > Public bug reported: > > Binary package hint: openoffice.org > > When I try to calc the interest rate from data bellow, I get wrong answer to > i = -185,49% > to nper = 12; fv = 0; pv = -1500; pmt = 500; type = 0; estimation = 0%. > But when I change estimation from 0% to 100% I get the write answer i = > 32,16%. > I know that both in mathematics the data above has two solutions and both > answers solve the same data problem. > But, with my HP 12 C, I do not need to worry about that because it always > gives me the wright answer. > > ProblemType: Bug > Architecture: amd64 > DistroRelease: Ubuntu 9.04 > Package: openoffice.org-core 1:3.0.1-9ubuntu3 > ProcEnviron: > PATH=(custom, no user) > LANG=pt_BR.UTF-8 > SHELL=/bin/bash > SourcePackage: openoffice.org > Uname: Linux 2.6.28-15-generic x86_64 > > ** Affects: openoffice.org (Ubuntu) > Importance: Undecided > Status: New > > > ** Tags: amd64 apport-bug > > -- > Bug on OpenOffice Calc Financial Calculator Formulas gives wrong value to > Interest Rate Calc > https://bugs.launchpad.net/bugs/420614 > You received this bug notification because you are a direct subscriber > of the bug. > > Status in “openoffice.org” package in Ubuntu: New > > Bug description: > Binary package hint: openoffice.org > > When I try to calc the interest rate from data bellow, I get wrong answer to > i = -185,49% > to nper = 12; fv = 0; pv = -1500; pmt = 500; type = 0; estimation = 0%. > But when I change estimation from 0% to 100% I get the write answer i = > 32,16%. > I know that both in mathematics the data above has two solutions and both > answers solve the same data problem. > But, with my HP 12 C, I do not need to worry about that because it always > gives me the wright answer. > > ProblemType: Bug > Architecture: amd64 > DistroRelease: Ubuntu 9.04 > Package: openoffice.org-core 1:3.0.1-9ubuntu3 > ProcEnviron: > PATH=(custom, no user) > LANG=pt_BR.UTF-8 > SHELL=/bin/bash > SourcePackage: openoffice.org > Uname: Linux 2.6.28-15-generic x86_64 _________________________________________________________________ Deixe suas conversas mais divertidas. Baixe agora mesmo novos emoticons. É grátis! http://specials.br.msn.com/ilovemessenger/pacotes.aspx ** Attachment added: "Bug_OpenOffice_Calc.ods" http://launchpadlibrarian.net/30966130/Bug_OpenOffice_Calc.ods -- Bug on OpenOffice Calc Financial Calculator Formulas gives wrong value to Interest Rate Calc https://bugs.launchpad.net/bugs/420614 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs