Excel 2000 Question

[Guest]

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?

 

[Ron Coderre]

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:
Tools>Options>Calculation
Select Automatic.

Does that help?

Ron

..................

 

[Guest]

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]

After re-reading your problem, I need a clarification.

Are you saying that if you use this formula:
=IF(C6="Trave","True","False")

And C6 contains "Trave",
The formula returns "True"?

That would be correct.

What do you want the formula to do?

Regards,
Ron