<div class="raw-html-embed">	The EXACT function is one of the <a href="../../docs/userguides/spreadsheet_editor/InsertFunction.aspx#textdata" onclick="onhyperlinkclick(this)">text and data functions</a>. Is used to compare data in two cells. The function returns TRUE if the data are the same, and FALSE if not.

	<h5 class="pt8">Syntax</h5>
	EXACT(text1, text2)
	The EXACT function has the following arguments:
	<table>
		<tbody>
			<tr>
				<th style="background-color: #f4f4f4" width="150ch">Argument</th>
				<th style="background-color: #f4f4f4">Description</th>
			</tr>
			<tr>
				<td>text1(2)</td>
				<td>Two text strings you want to compare.</td>
			</tr>
		</tbody>
	</table>

	<h5 class="pt8">Notes</h5>
	The EXACT function is case-sensitive.
	<a href="../../docs/userguides/spreadsheet_editor/InsertFunction.aspx#applyfunction" onclick="onhyperlinkclick(this)">How to apply</a> the EXACT function.

	<h5 class="pt8">Examples</h5>
	There are two arguments: text1 = A1; text2 = B1, where A1 is MyPassword, B1 is mypassword. So the function returns FALSE.
	<img alt="EXACT Function: FALSE" src="https://static-helpcenter.onlyoffice.com/exactfalse_7c641fb27a.png">
	If we change the A1 data converting all the uppercase letters to lowercase, the function returns TRUE:
	<img alt="EXACT Function: TRUE" src="https://static-helpcenter.onlyoffice.com/exacttrue_10415e01cf.png"></div>

EXACT function

Docs

EXACT function

Syntax

Notes

Examples

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