Friday, 14 November 2014

Exact function in excel

The exact function gives the output either true or false based on the comparison result of two cell values.

Example :

A1 = Mike

B1 = Mike


Output : True  as both values are same.

Note: This function is restricted to case sensitive values

Mike is not equal to mike


No comments:

Post a Comment