if,then statement returns a false because alpha string is more than 5
characters.
Example:
=IF(C6="Travel","True","False") and cell 'C6' does equal "travel". It works
if "trave" is used in statement and in cell it returns a 'true'.
Is this because of a setting in my worksheet?