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
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
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
Will
Not all chemicals are bad. Without chemicals such as hydrogen and oxygen for example, there would be no way to make water, a vital ingredient in beer.
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! )
Regards, Zack Barresse
Check out the KB! :|: BOARD TAGS: WHAT ARE THEY AND HOW DO I USE THEM
What is a Microsoft MVP? | Free Microsoft Courses | My Book on Excel Tables
You may want to try:
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"=AND(upper(O2)="DOWN",upper(M2)="UP")
Matt
A couple of simple examples
MD
Thanks guys for the super replys. I have the formula working now.
Max
Great!Originally Posted by Tenspeed39355
Just wrought out of curiosity, what was the problem, and the formula used to fix?
Regards, Zack Barresse
Check out the KB! :|: BOARD TAGS: WHAT ARE THEY AND HOW DO I USE THEM
What is a Microsoft MVP? | Free Microsoft Courses | My Book on Excel Tables
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