Problem using AND()

[peacelittleone]

I have the following data:


A B C
1 FALSE TRUE TRUE
2 FALSE TRUE TRUE
3 FALSE TRUE TRUE
4 TRUE TRUE TRUE


THe formula in C1 = and(a1,b1)

Why is it returning TRUE? Shouldn't it be FALSE?

ARGHHHHHHHHHHHHH....

TIA.

Heather

 

[Roger Govier]

Yes it should be FALSE.
It is for me.
Is calculation set to Manual?

 

[Tom Ogilvy]

Returns false for me. Do you have calculation set to Manual in
tools=>Options=>Calculation tab.

 

[peacelittleone]

All -

Thanks for all of your responses. I had another formula that wa
setting the "TRUE" and "FALSE" values instead of using TRUE and FALSE.

OLD =if(a2=b2,"TRUE","FALSE")

NEW = if(a2=b2,TRUE,FALSE)

Thanks again!

Heather