Author: Oscar Cronquist Article last updated on April 12, 2018

The EXACT function allows you to check if two values are precisely the same, it returns TRUE or FALSE. The EXACT function also considers upper case and lower case letters.

Formula in cell D3:

=EXACT(B3,C3)

Excel Function Syntax

EXACT(text1, text2)

Arguments

text1 The first value to compare. Required.
text2 The second value to compare. Required.

Comments


EXACT function ignores cell formatting differences.