Difference between revisions of "Documentation/How Tos/Calc: DISC function"
From Apache OpenOffice Wiki
< Documentation | How Tos
Javier Lopez (Talk | contribs) |
|||
Line 99: | Line 99: | ||
* Calc follows Excel's apparent use of <tt>'''YEARFRAC'''</tt> in calculating <tt>'''DISC'''</tt>. Both Excel and Calc calculate <tt>'''YEARFRAC'''</tt> incorrectly in certain circumstances, and these (small) errors are propagated to <tt>'''DISC'''</tt>. | * Calc follows Excel's apparent use of <tt>'''YEARFRAC'''</tt> in calculating <tt>'''DISC'''</tt>. Both Excel and Calc calculate <tt>'''YEARFRAC'''</tt> incorrectly in certain circumstances, and these (small) errors are propagated to <tt>'''DISC'''</tt>. | ||
− | {{ | + | {{SeeAlso|EN| |
* [[Documentation/How_Tos/Calc: PRICE function|PRICE]] | * [[Documentation/How_Tos/Calc: PRICE function|PRICE]] | ||
* [[Documentation/How_Tos/Calc: PRICEDISC function|PRICEDISC]] | * [[Documentation/How_Tos/Calc: PRICEDISC function|PRICEDISC]] |
Revision as of 09:31, 17 July 2018
CALC FUNCTIONS
- Financial FunctionsDepreciation
- AmordegrcAmorlincDbDdbSlnSydVdbPayment Streams, Annuities, Loans
- CumipmtCumipmt AddCumprincCumpinc AddFvFvscheduleIpmtIrrIspmtMirrNperNpvPmtPpmtPvRateRriXirrXnpvSecurities
-