AND - OR

[RST Engineering]

Is it just me, or are the AND and OR functions reversed logically? Is
there a tutorial somewhere on how to use them? The help files in
Excel are their usual confusing self.

Jim

 

[Niek Otten]

Please give an example of cell values, formula, expected and actual result

 

[Stan Brown]

Is it just me, or are the AND and OR functions reversed logically? Is
there a tutorial somewhere on how to use them? The help files in
Excel are their usual confusing self.

In a blank cell, I typed
=AND(
and then pressed Ctrl-A. The wizard popped up, with the description
"Checks whether all arguments are TRUE, and returns TRUE if all
arguments are TRUE."

Can you explain a little bit more about which part of that is
confusing or why it looks "reversed" to you?

 

[RST Engineering]

In a blank cell, I typed
=AND(
and then pressed Ctrl-A.

All that does on my machine is select all cells. Excel 2003.

The wizard popped up, with the description
"Checks whether all arguments are TRUE, and returns TRUE if all
arguments are TRUE."

Can you explain a little bit more about which part of that is
confusing or why it looks "reversed" to you?

Perhaps it is because I don't know the correct syntax. That's mostly
why I asked if there was a tutorial somewhere.

Jim

 

[RST Engineering]

Please give an example of cell values, formula, expected and actual result

It was more a general question, not a specific instance. Is there a
tutorial somewhere? I think I'm starting to understand that the
function looks inside the parentheses to see if all of them are true
(AND) or if any one of them is true (OR) and returns a zero if false
and 1 if true.

Jim.

 

[John]

Hi
http://www.techonthenet.com/excel/formulas/and.php
http://www.techonthenet.com/excel/formulas/or.php
Also you can Google for the excel "and & or" function
HTH
John