# EXACT Function in Excel

In this tutorial, you will learn the EXACT formula in excel. EXACT function in excel is useful to compare two data and give the result of TRUE logic value if the two of them are exactly the same or FALSE if not. This EXACT formula in excel is case sensitive.

## Why do We Need to Learn EXACT Formula in Excel?

In the processing that we do on a spreadsheet, sometimes we need to do a similarity comparison between two texts to be used in a formula that utilizes TRUE and FALSE logic values in its process. In the process, maybe we also need the comparison to be case sensitive on those two texts so the comparison result will not be wrong. This cannot be done if we use the manual comparison process in the spreadsheet.

The case example is when we want to use a product name data to look at the details of the product in a spreadsheet. In the data that we save on the spreadsheet, there is a product name that is the exactly same as the product name that we look for, and they are only differentiated with the capital or non-capital letters. If we use a manual comparison process to find the product name, then it will not detect the difference between the capital and non-capital letters on the product names. If the products have hundreds or even thousands of data, then it will be hard if the alternative of this is we have to look at each of the data one by one.

To help you in getting the comparison process right and make it pay attention to the capital or non-capital letters, then you can use the EXACT formula in excel. EXACT function in excel is useful for the comparison process of two data which also pays attention to the capital or non-capital letters of the two data. The EXACT formula in excel is very useful for you to learn if you often use a text comparison process in your processing/analysis on the spreadsheet.

## What is the EXACT Function in Excel?

EXACT function in excel is a function with the usage objective to get the logic value of TRUE or FALSE from the result of two data comparisons by having the case sensitive factor on the comparison process. The EXACT function in excel will give TRUE if the two data are exactly the same and FALSE if not.

Generally, the input of this formula can be explained as follows:

=EXACT(text1, text2)

Note:
• text1 = the first data to be compared
• text2 = the second data to be compared

## How to Use EXACT Formula in Excel?

The following will explain the writing of the EXACT function in excel. The EXACT formula in excel needs two required inputs which are the two data that you want to compare to get the TRUE or FALSE result.

## Using the EXACT Function in Excel

1. Type equal sign ( = ) in the cell where you want to put the result in 2. Type EXACT (can be with large and small letters) and open bracket sign after = 3. Input the first data or cell coordinate where the first data which you want to compare is after the open bracket sign. If you want to type a text manually without using a cell coordinate, then do not forget to type the text between two quotes signs (“”). Then type a comma sign ( , ) 4. Input the second data or cell coordinate where the second data which you want to compare is. If you want to type a text manually without using a cell coordinate, then do not forget to type the text between two quotes signs 5. Type close bracket sign 6. Type Enter
7. The process is done! ## Exercise

After you have learned the step-by-step writing of the EXACT formula in excel, now is the time to deepen your understanding by doing the following exercise!

### Questions

1. What is the logic value from the comparison result of the two texts in the row no. 1?
2. What is the logic value from the comparison result of the two texts in the row no. 2?
3. What is the logic value from the comparison result of the two texts in the row no. 3?

If you want to compare two data without being case sensitive, then you can use an equal sign ( = ) for your comparison process.  