Excel 2000 Question
 

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?

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?

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?

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


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