How to Use EXACT Function in Excel | Microsoft Excel

Exact Function compare two word, if both are same it will return TRUE  otherwise it will return FALSE

Syntax for EXACT Function


Arguments of EXCAT Function

text1: required. the word which we want to compare
text2: required. the word which is to be compared with text1.

Behaviour of EXACT Function

Here we have taken examples of some fruit names and compare text 1 and text2
EXACT Function is case sensitive so here if we compare same name on with upper later and lower latter it will give result as FALSE.

Here Apple and apple is different so EXACT Function will return FALSE
Same as Banana and Banana is same so Exact Function will return TRUE

Use of EXACT Function

Exact function is used to comapare two or more texts 

Return of EXACT Function

EXACT Function will return TRUE or FALSE


  1. Many thanks for sharing such incredible knowledge. It's really good for your Website.
    The info on your website inspires me greatly. This website I'm bookmarked. Maintain it and thanks again.
    I'm really impressed with your writing skills, as smart as the structure of your weblog.

    Microsoft Excel Crack
    iSkysoft Data Recovery Crack
    Proteus Crack

  2. I guess I am the only one who came here to share my very own experience. Guess what!? I am using my laptop for almost the past 6 years, but I had no idea of solving some basic issues. I do not know how to Download Cracked Pro Softwares But thankfully, I recently visited a website named
    All Pro Cracked Softwares Download
    Mirillis Action Crack
    Bootstrap Studio Crack
    Simplify3D Crack
    EaseUS Todo PCTrans Pro Crack
    FastKeys Crack