<div class="raw-html-embed">	The IFS 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>. It checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition.

	<h5 class="pt8">Syntax</h5>
	IFS(logical_test1, value_if_true1, [logical_test2, value_if_true2], ...)
	The IFS 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_test1</td>
				<td>The first condition to be evaluated to TRUE or FALSE.</td>
			</tr>
			<tr>
				<td>value_if_true1</td>
				<td>The value that returns if the logical_test1 is TRUE.</td>
			</tr>
			<tr>
				<td>logical_test2, value_if_true2, ...</td>
				<td>Additional conditions and values to return. These arguments are optional. You can check up to 127 conditions.</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 IFS function.

	<h5 class="pt8">Examples</h5>
	There are the following arguments: logical_test1 = A1&lt;100, value_if_true1 = 1, logical_test2 = A1&gt;100, value_if_true2 = 2, where A1 is 120. The second logical expression is TRUE. So the function returns 2.
	<img alt="IFS Function" src="https://static-helpcenter.teamlab.info/ifs_7025fc4952.png"></div>

IFS Function

Docs

Argument	Description
*logical_test1*	The first condition to be evaluated to TRUE or FALSE.
*value_if_true1*	The value that returns if the *logical_test1* is TRUE.
*logical_test2, value_if_true2, ...*	Additional conditions and values to return. These arguments are optional. You can check up to 127 conditions.

IFS Function

Syntax

Notes

Examples

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