ExcelBanter - Problem using AND()

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Problem using AND() (https://www.excelbanter.com/excel-worksheet-functions/37634-problem-using.html)

peacelittleone

Problem using AND()

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

Roger Govier

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

--
Regards
Roger Govier
"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

Tom Ogilvy

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

peacelittleone

All -

Thanks for all of your responses. I had another formula that was
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.

--
peacelittleone

------------------------------------------------------------------------
peacelittleone's Profile: http://www.excelforum.com/member.php...o&userid=20937
View this thread: http://www.excelforum.com/showthread...hreadid=391065

All times are GMT +1. The time now is 05:08 PM.