EXACT Function or EXACT Formula in Excel with example

EXACT Function or EXACT Formula in Excel with example

Exact

As word describes, Exact function evaluates to strings and returns boolean result as TRUE or FALSE. If string is exact match then it will return TRUE else FALSE. Point to be noticed that Exact Function works on Case sensitive logic as shown below:

Syntax

=EXACT(text1, text2)

  • text1: a mandatory argument referring to a string which needs to be compared or matched with text2.
  • text2: a mandatory argument referring to a string which needs to be compared or matched with text1.

Formula

Output

Next >> Extract Emails from Outlook to Excel with code example

Leave a Reply

Your email address will not be published.