A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

AND - OR



 
 
Thread Tools Display Modes
  #1  
Old May 20th, 2010, 08:57 PM posted to microsoft.public.excel.newusers
RST Engineering
external usenet poster
 
Posts: 7
Default AND - OR

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
  #2  
Old May 20th, 2010, 10:23 PM posted to microsoft.public.excel.newusers
Niek Otten
external usenet poster
 
Posts: 2,533
Default AND - OR

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"RST Engineering" wrote in message
...
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


  #3  
Old May 21st, 2010, 03:56 AM posted to microsoft.public.excel.newusers
Stan Brown
external usenet poster
 
Posts: 536
Default AND - OR

On Thu, 20 May 2010 12:57:26 -0700, RST Engineering wrote:

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?

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
Shikata ga nai...
  #4  
Old May 22nd, 2010, 12:34 AM posted to microsoft.public.excel.newusers
RST Engineering
external usenet poster
 
Posts: 7
Default AND - OR

On Thu, 20 May 2010 22:56:29 -0400, Stan Brown
wrote:



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

  #5  
Old May 22nd, 2010, 12:37 AM posted to microsoft.public.excel.newusers
RST Engineering
external usenet poster
 
Posts: 7
Default AND - OR

On Thu, 20 May 2010 23:23:06 +0200, "Niek Otten"
wrote:

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.

  #6  
Old May 22nd, 2010, 01:44 AM posted to microsoft.public.excel.newusers
John
external usenet poster
 
Posts: 563
Default AND - OR

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
"RST Engineering" wrote in message
...
On Thu, 20 May 2010 22:56:29 -0400, Stan Brown
wrote:



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


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:19 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.