<div class="raw-html-embed">	<p>The <b>VAR</b> function is one of the <a href="../../docs/userguides/spreadsheet_editor/InsertFunction.aspx#statistical" onclick="onhyperlinkclick(this)">statistical functions</a>. It is used to analyze the set of values and calculate the sample variance.</p>

	<h5 class="pt8">Syntax</h5>
	<p><b><em>VAR(number1, [number2], ...)</em></b></p>
	<p>The <b>VAR</b> function has the following arguments:</p>
	<table>
		<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>number1/2/n</em></b></td>
				<td>Up to 255 numeric values for which you want to calculate the variance.</td>
			</tr>
		</tbody>
	</table>

	<h5 class="pt8">Notes</h5>
	<p>Empty cells, logical values, text, or error values supplied as part of an array are ignored. If they are supplied directly to the function, text representations of numbers and logical values are interpreted as numbers.</p>
	<p><a href="../../docs/userguides/spreadsheet_editor/InsertFunction.aspx#howtoapplyfunctions_block" onclick="onhyperlinkclick(this)">How to apply</a> the <b>VAR</b> function.</p>

	<h5 class="pt8">Examples</h5>
	<p>The figure below displays the result returned by the <b>VAR</b> function.</p>
	<p><img alt="VAR Function" src="https://static-helpcenter.onlyoffice.com/var_c80a41f401.png"></p></div>

VAR function

Docs

VAR function

Syntax

Notes

Examples

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