<div class="raw-html-embed">	The IF function is one of the <a href="https://helpcenter.onlyoffice.com/onlyoffice-editors/onlyoffice-spreadsheet-editor/UsageInstructions/InsertFunction.aspx#logical" onclick="onhyperlinkclick(this)">logical functions</a>. Is used to check the logical expression and return one value if it is TRUE, or another if it is FALSE.

	<h5 class="pt8">Syntax</h5>
	IF(logical_test, value_if_true, [value_if_false])
	The IF function has the following arguments:
	<table style="width: 40%">
		<tbody>
			<tr>
				<th style="background-color: #f4f4f4" width="150ch">Argument</th>
				<th style="background-color: #f4f4f4">Description</th>
			</tr>
			<tr>
				<td>logical_test</td>
				<td>The condition that you want to test.</td>
			</tr>
			<tr>
				<td>value_if_true</td>
				<td>The value to be returned if the result is TRUE.</td>
			</tr>
			<tr>
				<td>value_if_false</td>
				<td>The value to be returned if the result is FALSE.</td>
			</tr>
		</tbody>
	</table>

	<h5 class="pt8">Notes</h5>
	<a href="https://helpcenter.onlyoffice.com/onlyoffice-editors/onlyoffice-spreadsheet-editor/UsageInstructions/InsertFunction.aspx#applyfunction" onclick="onhyperlinkclick(this)">How to apply</a> the IF function.

	<h5 class="pt8">Examples</h5>
	There are three arguments: logical_test = A1&lt;100, value_if_true = 0, value_if_false = 1, where A1 is 12. This logical expression is TRUE. So the function returns 0.
	<img alt="IF Function: TRUE" src="https://static-helpcenter.teamlab.info/iftrue_14f12aab5a.png">
	If we change the A1 value from 12 to 112, the function returns 1:
	<img alt="IF Function: FALSE" src="https://static-helpcenter.teamlab.info/iffalse_243cb0e8e6.png"></div>

IF Function

Docs

Argument	Description
*logical_test*	The condition that you want to test.
*value_if_true*	The value to be returned if the result is TRUE.
*value_if_false*	The value to be returned if the result is FALSE.

IF Function

Syntax

Notes

Examples

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