Excel Exact Formula

Learn How to use Excel Exact Formula:

Excel Exact Formula compare two cells and returns True if they match, otherwise it returns False. Importantly, Exact Function is Case-Sensitive. However, it doesn’t consider the formatting differences.

Exact Function works with Text and Numbers both.

Exact Function Syntax: Exact(Text1, Text2)

Text1 and Text2: Cells having Text strings or Data that has to be compared.

Example – Excel Exact Formula:

Excel Exact Formula

Example: Excel Formula

Since Exact Function is Case-Sensitive, the result of Example – 1 is False.

Example – 2 is True. Both Cells are same.

Hope you may find this useful.

You may also consider learning Excel Case-Insensitive Match.

Categories: Formulas

Tags: ,

Leave a Reply

%d bloggers like this: