Skip to main content

EXACT

Definition

Tests whether two strings are identical.

Sample Usage

EXACT(A1,A2)

EXACT("foo",A3)

Syntax

`EXACT(string1, string2)

  • string1 - The first string to compare

  • string2 - The second string to compare

Notes

  • EXACT requires the two strings to have the exact same characters, including identical case and identical spaces or hidden characters.

In order to use the EXACT formula, start with your edited Excellentable:

 

 

Then type in the EXACT formula in the area you would like to display the outcome:

 

By adding the values you would like to calculate the EXACT formula for, Excellentable will generate the outcome:

 

A
B
1
First String
Second String
2
string
string
3
String
string
4
5
6
Check whether the strings in the first row match:
TRUE
7
8
Check whether the strings in the second row match ("S" is uppercase in A3):
FALSE

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.