<div class="raw-html-embed"><p>The <b>PDURATION</b> function is one of the <a href="https://helpcenter.onlyoffice.com/onlyoffice-editors/onlyoffice-spreadsheet-editor/UsageInstructions/InsertFunction.aspx#financial" onclick="onhyperlinkclick(this)">financial functions</a>. It is used to calculate the number of periods required by an investment to reach a specified value.</p>
            <h5 class="pt8">Syntax</h5>
            <p><b><em>PDURATION(rate, pv, fv)</em></b></p>
            <p>The <b>PDURATION</b> function has the following arguments:</p>
            <table style="width: 40%">
                <tbody><tr>
                    <th style="background-color: #f4f4f4" width="150ch"><b>Argument</b></th>
                    <th style="background-color: #f4f4f4"><b>Description</b></th>
                </tr>
                <tr>
                    <td><b><em>rate</em></b></td>
                    <td>The interest rate per period.</td>
                </tr>
				<tr>
                    <td><b><em>pv</em></b></td>
                    <td>The present value of the investment.</td>
                </tr>
				<tr>
                    <td><b><em>fv</em></b></td>
                    <td>The desired future value of the investment.</td>
                </tr>
            </tbody></table>
            <h5 class="pt8">Notes</h5>
            <p>All arguments must be represented by positive numbers.</p>            
            <p><a href="https://helpcenter.onlyoffice.com/onlyoffice-editors/onlyoffice-spreadsheet-editor/UsageInstructions/InsertFunction.aspx#applyfunction" onclick="onhyperlinkclick(this)">How to apply</a> the <b>PDURATION</b> function.</p>
            
            <h5 class="pt8">Examples</h5>
            <p>The figure below displays the result returned by the <b>PDURATION</b> function.</p>
            <p><img alt="PDURATION Function" src="https://static-helpcenter.teamlab.info/pduration_3abc14a903.png"></p></div>

PDURATION function

Docs

Argument	Description
*rate*	The interest rate per period.
pv	The present value of the investment.
fv	The desired future value of the investment.

PDURATION function

Syntax

Notes

Examples

Host ONLYOFFICE Docs on your own server or use it in the cloud