Wednesday, 23 August 2017

EXACT Function

EXACT Function

This function used to compare two text strings whether they are same or not. If they are same it will returns "TRUE" else returns "FALSE". It is case sensitive.

Syntax: EXACT(text1,text2)

Example: =EXACT("excel","Excel")
Result: FALSE

Example: =EXACT("microsoft","microsoft")
Result: TRUE

 

No comments:

Post a Comment