<div class="raw-html-embed"><p>The <b>XNPV</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 net present value for an investment based on a specified interest rate and a schedule of irregular payments.</p>
			<h5 class="pt8">Syntax</h5> 
			<p><b><em>XNPV(rate, values, dates)</em></b></p> 
			<p>The <b>XNPV</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 discount rate for the investment.</td>
					</tr>
					<tr>
						<td><b><em>values</em></b></td>
						<td>An array that contains the income (positive values) or payment (negative values) amounts. At least one of the values must be negative and at least one positive.</td>
					</tr>
					<tr>
						<td><b><em>dates</em></b></td>
						<td>An array that contains the payment dates when the payments are made or received.</td>
					</tr>
				</tbody></table>
			<h5 class="pt8">Notes</h5>			            
			<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>XNPV</b> function.</p>
			
			<h5 class="pt8">Examples</h5>
            <p>The figure below displays the result returned by the <b>XNPV</b> function.</p>
			<p><img alt="XNPV Function" src="https://static-helpcenter.teamlab.info/xnpv_3bca0ca12e.png"></p></div>

XNPV function

Docs

Argument	Description
*rate*	The discount rate for the investment.
*values*	An array that contains the income (positive values) or payment (negative values) amounts. At least one of the values must be negative and at least one positive.
*dates*	An array that contains the payment dates when the payments are made or received.

XNPV function

Syntax

Notes

Examples

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