I did check this and it is set to automatic. I also tried the (F9), but it
did not change the result.

Thank you, do you have any other ideas?

"Ron Coderre" wrote:

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?