It sounds like you have calculaton set to manual. If you press the F9 key
(recalc) does the formula display the correct value?

If yes:
ToolsOptionsCalculation
Select Automatic.

Does that help?

Ron

..................
"Troy" wrote in message
...
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?