### Excel EXACT Function

This Excel Tutorial demonstrates how to use the Excel EXACT Function in Excel to test if cells are exactly the same, with formula examples.

## EXACT Function Description:

The EXACT Function Test if two text cells are exactly equal. Returns TRUE or FALSE. Case-sensitive.

## Formula Examples: Example Formula Result
Matches =EXACT(C5,D5) True
Doesn’t Match =EXACT(C6,D6) False
Case Doesn’t Match =EXACT(C8,D8) False
Case Doesn’t Match: Use LOWER =EXACT(lower(C9),lower(D9)) True
Format Doesn’t Match =EXACT(C10,D10) True

## Syntax and Arguments:

The Syntax for the EXACT Formula is:

### Function Arguments ( Inputs ):

text1 – A string of text.

text2 – A string of text.

The EXACT Function is case-sensitive. To ignore case, use LOWER (or UPPER) to put the strings of text in the same case. <>

Erroneous spaces at the beginning or end of the text string will result in a value of FALSE. Use the TRIM Function to remove erroneous spaces <>

The EXACT Function ignores cell formatting. ex. 0.08 = 8%

`=AND(`  