Excel Exact function


The Excel EXACT function is another condition function that returns logical values. 

Thus if the condition is met, Excel returns the TRUE result otherwise it returns the text FALSE.

Conditional functions play a major role in dynamic Excel modeling as these provide the opportunity to vary results if the particular scenario changes.

Logical Value means TRUE or FALSE text, either written or returned from a function.

In Excel EXACT function if the text in referred cells is not the same, it means the condition is not met and the FALSE result will be returned.

NOTE:- The EXACT function is case sensitive and even if the text is the same but in a different case ( Propper, Lower, Upper), this function will return the FALSE result. 

This can be illustrated in the example given in the image above. B5, B6, and B7 all contain the same text i.e. Excel but as in cell B7, the word is written upper case.



The EXACT function’s syntax has the following arguments:

  • text1 Required.

The text1 argument refers to the 1st text required to be compared with the 2nd text.

  • text2 Required.

The text2 argument refers to the 2nd text required to be compared with the 1st  text.

NOTE:- This function takes only two test arguments.


Organically grow the holistic world view of disruptive innovation via empowerment.
OUR LOCATIONSWhere to find us
GET IN TOUCHSocial links
Taking seamless key performance indicators offline to maximise the long tail.

Copyright by Excel Accountancy. All rights reserved.

Copyright by BoldThemes. All rights reserved.