Breadcrumbs

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:

EXACT_1.png

 

 

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

EXACT_2.png

EXACT_3.png

 

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

EXACT_4.png

EXACT_6.png

 

There were errors rendering macro:

  • An unknown error occurred.