Using the AND command

[Tenspeed39355]

Could someone please show me how to use the AND command.
I have tried the following but I must be leaving something out.
=AND(O2="down",M2="up") Both O2 and M2 should equal a TRUE. What am I doing
wrong. Thanks
Max

[WillR]

Nothing wrong with that formula

It will return TRUE if the value in O2 is "down" & the value in M2 is "up"

FALSE if either or both are not

[Zack Barresse]

Hi,

Are you sure you want an AND and not an OR statement? How about posting your entire formula along with what data your attempting to manipulate. You can upload zipped attachments of your file if you'd like.

(Hi Will! Still feeding the penguin I hope! )

[mvidas]

You may want to try:

=AND(upper(O2)="DOWN",upper(M2)="UP")

That just ignores the case in O2 and M2. Not sure if that's the issue, but I can't think of what else the issue is, why it wouldn't return TRUE if o2 is "down" and m2 is "up"
Matt

[mdmackillop]

A couple of simple examples
MD

[CBrine]

Another Option that might help is the trim.

=AND(upper(trim(O2))="DOWN",upper(trim(M2))="UP")

HTH

[Tenspeed39355]

Thanks guys for the super replys. I have the formula working now.

Max

[Zack Barresse]

Thanks guys for the super replys. I have the formula working now.

Max

Great!

Just wrought out of curiosity, what was the problem, and the formula used to fix?

[Tenspeed39355]

Firefytr
In my first post I said the following.
=AND(O2="down",M2="up") Both O2 and M2 should equal a TRUE. What am I doing
wrong. Thanks
I said a misstatement. In my ss I had =AND(O2="FALSE". When I changed it to "down" that fixed the problem. Sorry for the confusion.
Max