<div class="raw-html-embed">	The AND 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 is used to check if the logical value you enter is TRUE or FALSE. The function returns TRUE if all the arguments are TRUE.

	<h5 class="pt8">Syntax</h5>
	AND(logical1, [logical2], ...)
	The AND 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>logical1/2/n</td>
				<td>A condition that you want to check if it is TRUE or 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 AND function.
	The function returns FALSE if at least one of the arguments is FALSE.

	<h5 class="pt8">Examples</h5>
	There are three arguments: logical1 = A1&lt;100, logical2 = 34&lt;100, logical3 = 50&lt;100, where A1 is 12. All these logical expressions are TRUE. So the function returns TRUE.
	<img alt="AND Function: TRUE" src="https://static-helpcenter.teamlab.info/andtrue_db129dc34e.png">
	If we change the A1 value from 12 to 112, the function returns FALSE:
	<img alt="AND Function: FALSE" src="https://static-helpcenter.teamlab.info/andfalse_c282cabbea.png"></div>

AND Function

Docs

AND Function

Syntax

Notes

Examples

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