Returns false for me. Do you have calculation set to Manual in
tools=Options=Calculation tab.
--
Regards,
Tom Ogilvy
"peacelittleone"
<peacelittleone.1sw8qp_1122577587.9858@excelforu m-nospam.com wrote in
message news:peacelittleone.1sw8qp_1122577587.9858@excelfo rum-nospam.com...
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.
--
peacelittleone
------------------------------------------------------------------------
peacelittleone's Profile:
http://www.excelforum.com/member.php...o&userid=20937
View this thread: http://www.excelforum.com/showthread...hreadid=391065