Menu
EXCEL EXACT FUNCTION
Excel EXACT Function Introduction
The EXACT Function falls under the Excel Textual functionsFunctionsList of the most significant Functions for financial experts. This study guide contains hundreds of functions that are essential for an Excel analyst to know. The function aids in determining whether two or more given text strings or values are absolutely equal and, if so, returns TRUE. Otherwise, FALSE is returned. Case is taken into account when using the EXACT function.
Description of Excel EXACT Function
Syntax :
=EXACT(text1, text2, …)
Parameters :
- Text1 (mandatory parameter) – This is the first string to be joined. It might consist of two text strings, integers, or logical values.
- Text2 (mandatory parameter) – The second text string. If the two strings are identical, the EXACT function returns TRUE.
- If the two strings are not the same, the EXACT method returns FALSE.
Step By Step Guide of EXACT Function
Example :
Assume we want to compare the following information:
| Zone | Zone |
|---|---|
| North | NORTH |
| South | South |
| Zone | zone |
Key Points
- Finance Excel Functions
Excel for Finance - This Excel for Finance tutorial will teach you the top ten formulae and functions you need to know in order to be a competent financial analyst in Excel.
- Course on Advanced Excel Formulas Advanced Excel Formulas You Should Know Advanced Excel Formulas You Must Know These sophisticated Excel formulae are essential to understand and will take you company’s financial abilities to the next level. Download our free Excel booklet!
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
