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

=EXACT(A1,B1)

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