Excel EXACT() Function

The EXACT() function in excel checks whether the specified values (texts, numbers) are exactly the same or not. It returns a Boolean value TRUE if the compared values are same, else it will return FALSE. It is a case-sensitive function.

Syntax

EXACT(Text1, Text2)

Parameter

Text1 (required)- This parameter represents the first string which you want to check.

Text (required)- This parameter represents the second string which you want to test against.

Category

Text

Return

This function returns a Boolean value TRUE if the compared values are the same, else it will return FALSE.

Example 1

Objective: Using the EXACT function, evaluate whether the values specified in Col A and Col B are equal or not.

Col A	Col B	Result	Formula
EXCEL	EXCEL	TRUE	=EXACT(A19,B19)
EXCEL	Excel	FALSE	=EXACT(A20,B20)
12345	12345	TRUE	=EXACT(A21,B21)
1 234	1234	FALSE	=EXACT(A22,B22)

NOTE: You will notice, the result of ROW 20 is FALSE. It is so because the EXACT function is case-sensitive. The first value is in the upper case (EXCEL), whereas the second one (Excel) is a combination of the upper and lower case.

Example 2

Objective: Write a formula using EXACT to check if the values in Col A and Col B are the same or not

Col A	Col B	Results	Formula
EQUAL	EQUal	FALSE	=EXACT(A30,B30)
TEST	TEST	TRUE	=EXACT(A31,B31)
1234	1234	TRUE	=EXACT(A32,B32)
1.1	100.1	FALSE	=EXACT(A33,B33)

Related Topics

Formats in Excel

What are the formats? Formats are different options that one uses to change the appearance of data (maybe text, number, etc..) in an excel file. They do not change the value of the...

3 minutes read.

Separate Strings in Excel

How to Separate String in Excel Day by day, Microsoft Excel is increasing for business and personal use. It is a combination of numbers and alphabets based on the data provided....

4 minutes read.

Excel OFFSET () Function

Excel OFFSET () Function The OFFSET() function in excel returns range of cells that is a specified number of rows and columns from an initial specified range. Syntax OFFSET (reference, rows, cols, [height], [width]) Parameter reference(required)-...

2 minutes read.

Excel RIGHT() Function

The RIGHT() function in excel returns the rightmost characters from a text value. This function is used for data manipulation. Syntax RIGHT(Text, [num_chars]) Parameter Text (required)- This parameter represents the string from which you want to find...

1 minute read.

Excel Function and Formulas

Excel Today() Function The today() function returns the serial number of today’s date as per system number of today’s date as per system’s regional settings. Syntax Today() Parameter NA Category Date & Time Returns This function returns today's date...

4 minutes read.

Excel EOMONTH() Function

Excel EOMONTH() Function The EOMONTH() function in excel returns the serial number of the last day of the month before or after a specified number of months. Syntax EOMONTH (Start_Date, Month) Parameter Start_Date(required)- This parameter...

1 minute read.

Basics of Excel

Different ways to open an excel file There are various ways to open an excel file, some of them are listed below - From Start Menu:Go to the start menu and search for Ms-Excel...

5 minutes read.

Excel EXACT() Function

The EXACT() function in excel checks whether the specified values (texts, numbers) are exactly the same or not. It returns a Boolean value TRUE if the compared values are same, else it...

1 minute read.

Dependent Combo box in Excel VBA

Adding the particular dependent box in the created User form with the help of the Microsoft Excel VBA is considered essential and crucial in Microsoft Excel. Here, in this tutorial, we...

7 minutes read.

Excel HLOOKUP() Function

Excel HLOOKUP() Function The HLOOKUP() function in excel is used to search a value in the topmost row of a table and then return a corresponding value in the same column for the specified...

2 minutes read.

How to create drop down in excel?

How to create drop down in excel? Drop-down lists are mostly used to facilitate data entry operations. They are commonly used in interactive websites or applications. Microsoft has expanded his Excel's data validation feature...

5 minutes read.

Text to columns in Excel

Microsoft Excel is widely used in startups to large companies. The data are entered in required rows and columns, and sometimes the data entered in one cell needs to enter...

4 minutes read.

Dependent Drop-down List in Excel

Excel forms are used to fetch data from the end user. When we have to give choices, we often use the drop-down feature of Excel. In this tutorial, we won’t...

7 minutes read.

Excel Nested IF’s Function

Excel Nested IF’s Function This function in excel helps in checking multiple conditions together by using IF conditions within the IF condition. Syntax if(Logical_Test, [value_if_true], if(Logical_Test, [value_if_true] , [value_if_false])) Parameter Logical_Test (required)- This parameter represents the condition which...

2 minutes read.

Excel VALUE() Function

The VALUE() function in excel converts the specific text representing a number (i.e., a number, date, or time format) into a numerical value. Syntax VALUE(Text) Parameter Text(required)- This parameter represents the string that you want...

1 minute read.

Solver in Excel

What is Solver? Microsoft Excel facilitates an add-in programming tool known as Solver that uses operational research techniques to find the optimal solutions for objective problems. This tool operates with a group of...

5 minutes read.

Excel DAYS() Function

The DAYS() function in excel returns the number of days that exist between two dates. Syntax DAYS (end_date, start_date) Parameter end_date (required)- This parameter represents the end date. start_date (required)- This parameter represents the start date. Category Date...

1 minute read.

Excel EDATE() Function

Excel EDATE() Function The EDATE() function in excel returns the serial number of the date that is the indicated number of months before or after the start date. Syntax EDATE(Start_Date, Month) Parameter Start_Date(required)- This parameter represents...

1 minute read.

Thermometer Chart in the Microsoft Excel

It was known that the thermometer chart is basically based on a single data point and that in turn could be used to show the achievement percentage. It primarily depends...

7 minutes read.

Excel INDEX () Function

Excel INDEX () Function The INDEX() function in excel returns a value from a list of tables based on the intersection of a row and a column position. This function is used with the...

2 minutes read.