The Similarity function performs the Levenshtein similarity calculation on two strings and return the similarity as a percentage (a single of range 0 to 1).

The syntax of the function is:

=Similarity(String1, String2, MinimumPercentage)


where

String1 is the first string to compare.

String2 is the second string to compare.

MinimumPercentage is the minimum percentage of similarity that is allowed for a match.


Created with the Personal Edition of HelpNDoc: Full-featured EPub generator