 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / November 2006More on Boolean
I read the following and have a couple of questions. >> A Boolean logical input or output always takes one of two logic levels. These logic levels can go by many names including: on / off, high (H) / low (L), one (1) / zero (0), true (T) / false (F), positive / negative, positive / ground, open circuit / close circuit, potential difference / no difference, yes / no. In computer science, the Boolean datatype, sometimes called the logical datatype, is a primitive datatype having two values: one and zero (sometimes called true and false). It is the special case of a binary numeric datatype of only one digit, or bit..... This datatype is used in Boolean and other operations such as and (AND, &, *), or (OR, |, +), exclusive or/not equivalent (xor, NEQV, ^), equal (EQV, =, ==) and not (NOT, ~, !) which correspond to some of the operations of Boolean algebra and arithmetic. << I have no problem understanding the above and I always know that TRUE is 1 and FALSE is 0 *theoretically*. However, I have discovered that in Excel, 0 is FALSE and anything other than 0 including negative values is TRUE and not just 1 is TRUE. Is there a missing piece that I should know of? I also read: >> Digital circuits are the most common mechanical representation of Boolean algebra and are the basis of all digital computers. They can also be used to process digital information without being connected up as a computer. Such circuits are referred to as "random logic". << In other words, digital circuits = "random logic." Wonder if I can say Boolean is random logic? Don't want to bother with DeMorgan Theorem as long as I know how to write my formula. Thank you for reading. Epinn Hi Epinn: Things are different in VBA: "When Boolean values are converted to other data types, False becomes 0 and True becomes -1." for example: Sub what_is_truth() MsgBox (1 = 1) MsgBox (1 = 2) MsgBox ((1 = 1) * 1) MsgBox ((1 = 2) * 1) End Sub  SignatureGary's Student > I read the following and have a couple of questions. > >> A Boolean logical input or output always takes one of two logic levels. These logic levels can go by many names including: on / off, high (H) / low (L), one (1) / zero (0), true (T) / false (F), positive / negative, positive / ground, open circuit / close circuit, potential difference / no difference, yes / no. [quoted text clipped - 18 lines] > > Epinn In computer programming, True is -1, all bits set, False is 0, all bits unset. Excel, as against VBA, for some reason decided that True was 1. And to compound the difference, they decided any value other than 0 was True. After a while, you stop worrying/wondering why, you just accept it as a fact and get on with it. SignatureHTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) I read the following and have a couple of questions. >> A Boolean logical input or output always takes one of two logic levels. These logic levels can go by many names including: on / off, high (H) / low (L), one (1) / zero (0), true (T) / false (F), positive / negative, positive / ground, open circuit / close circuit, potential difference / no difference, yes / no. In computer science, the Boolean datatype, sometimes called the logical datatype, is a primitive datatype having two values: one and zero (sometimes called true and false). It is the special case of a binary numeric datatype of only one digit, or bit..... This datatype is used in Boolean and other operations such as and (AND, &, *), or (OR, |, +), exclusive or/not equivalent (xor, NEQV, ^), equal (EQV, =, ==) and not (NOT, ~, !) which correspond to some of the operations of Boolean algebra and arithmetic. << I have no problem understanding the above and I always know that TRUE is 1 and FALSE is 0 *theoretically*. However, I have discovered that in Excel, 0 is FALSE and anything other than 0 including negative values is TRUE and not just 1 is TRUE. Is there a missing piece that I should know of? I also read: >> Digital circuits are the most common mechanical representation of Boolean algebra and are the basis of all digital computers. They can also be used to process digital information without being connected up as a computer. Such circuits are referred to as "random logic". << In other words, digital circuits = "random logic." Wonder if I can say Boolean is random logic? Don't want to bother with DeMorgan Theorem as long as I know how to write my formula. Thank you for reading. Epinn Thank you and I'll "get on with it." Have you read my latest discovery (11/25/2006 same forum)? Biff and Don were surprised and Don said he would refer the thread to the L & G lists which I have no idea what the lists are. I'll do my best to give Boolean a rest. Epinn In computer programming, True is -1, all bits set, False is 0, all bits unset. Excel, as against VBA, for some reason decided that True was 1. And to compound the difference, they decided any value other than 0 was True. After a while, you stop worrying/wondering why, you just accept it as a fact and get on with it. SignatureHTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) I read the following and have a couple of questions. >> A Boolean logical input or output always takes one of two logic levels. These logic levels can go by many names including: on / off, high (H) / low (L), one (1) / zero (0), true (T) / false (F), positive / negative, positive / ground, open circuit / close circuit, potential difference / no difference, yes / no. In computer science, the Boolean datatype, sometimes called the logical datatype, is a primitive datatype having two values: one and zero (sometimes called true and false). It is the special case of a binary numeric datatype of only one digit, or bit..... This datatype is used in Boolean and other operations such as and (AND, &, *), or (OR, |, +), exclusive or/not equivalent (xor, NEQV, ^), equal (EQV, =, ==) and not (NOT, ~, !) which correspond to some of the operations of Boolean algebra and arithmetic. << I have no problem understanding the above and I always know that TRUE is 1 and FALSE is 0 *theoretically*. However, I have discovered that in Excel, 0 is FALSE and anything other than 0 including negative values is TRUE and not just 1 is TRUE. Is there a missing piece that I should know of? I also read: >> Digital circuits are the most common mechanical representation of Boolean algebra and are the basis of all digital computers. They can also be used to process digital information without being connected up as a computer. Such circuits are referred to as "random logic". << In other words, digital circuits = "random logic." Wonder if I can say Boolean is random logic? Don't want to bother with DeMorgan Theorem as long as I know how to write my formula. Thank you for reading. Epinn Saw it but didn't study it. I also noticed that Don raised in on the ListServ, but again I haven't followed it. -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) Thank you and I'll "get on with it." Have you read my latest discovery (11/25/2006 same forum)? Biff and Don were surprised and Don said he would refer the thread to the L & G lists which I have no idea what the lists are. I'll do my best to give Boolean a rest. Epinn In computer programming, True is -1, all bits set, False is 0, all bits unset. Excel, as against VBA, for some reason decided that True was 1. And to compound the difference, they decided any value other than 0 was True. After a while, you stop worrying/wondering why, you just accept it as a fact and get on with it. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Epinn" <someone@example.com.NO_SPAM> wrote in message news:uFsFwZPEHHA.3396@TK2MSFTNGP02.phx.gbl... I read the following and have a couple of questions. >> A Boolean logical input or output always takes one of two logic levels. These logic levels can go by many names including: on / off, high (H) / low (L), one (1) / zero (0), true (T) / false (F), positive / negative, positive / ground, open circuit / close circuit, potential difference / no difference, yes / no. In computer science, the Boolean datatype, sometimes called the logical datatype, is a primitive datatype having two values: one and zero (sometimes called true and false). It is the special case of a binary numeric datatype of only one digit, or bit..... This datatype is used in Boolean and other operations such as and (AND, &, *), or (OR, |, +), exclusive or/not equivalent (xor, NEQV, ^), equal (EQV, =, ==) and not (NOT, ~, !) which correspond to some of the operations of Boolean algebra and arithmetic. << I have no problem understanding the above and I always know that TRUE is 1 and FALSE is 0 *theoretically*. However, I have discovered that in Excel, 0 is FALSE and anything other than 0 including negative values is TRUE and not just 1 is TRUE. Is there a missing piece that I should know of? I also read: >> Digital circuits are the most common mechanical representation of Boolean algebra and are the basis of all digital computers. They can also be used to process digital information without being connected up as a computer. Such circuits are referred to as "random logic". << In other words, digital circuits = "random logic." Wonder if I can say Boolean is random logic? Don't want to bother with DeMorgan Theorem as long as I know how to write my formula. Thank you for reading. Epinn I have one more interested party now. Can you tell me if I add posts to my original thread in Newuser, will they show up in ListServ? Epinn Saw it but didn't study it. I also noticed that Don raised in on the ListServ, but again I haven't followed it. -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) Thank you and I'll "get on with it." Have you read my latest discovery (11/25/2006 same forum)? Biff and Don were surprised and Don said he would refer the thread to the L & G lists which I have no idea what the lists are. I'll do my best to give Boolean a rest. Epinn "Bob Phillips" <bob.NGs@somewhere.com> wrote in message news:uqdGMMVEHHA.4024@TK2MSFTNGP04.phx.gbl... In computer programming, True is -1, all bits set, False is 0, all bits unset. Excel, as against VBA, for some reason decided that True was 1. And to compound the difference, they decided any value other than 0 was True. After a while, you stop worrying/wondering why, you just accept it as a fact and get on with it. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) I read the following and have a couple of questions. >> A Boolean logical input or output always takes one of two logic levels. These logic levels can go by many names including: on / off, high (H) / low (L), one (1) / zero (0), true (T) / false (F), positive / negative, positive / ground, open circuit / close circuit, potential difference / no difference, yes / no. In computer science, the Boolean datatype, sometimes called the logical datatype, is a primitive datatype having two values: one and zero (sometimes called true and false). It is the special case of a binary numeric datatype of only one digit, or bit..... This datatype is used in Boolean and other operations such as and (AND, &, *), or (OR, |, +), exclusive or/not equivalent (xor, NEQV, ^), equal (EQV, =, ==) and not (NOT, ~, !) which correspond to some of the operations of Boolean algebra and arithmetic. << I have no problem understanding the above and I always know that TRUE is 1 and FALSE is 0 *theoretically*. However, I have discovered that in Excel, 0 is FALSE and anything other than 0 including negative values is TRUE and not just 1 is TRUE. Is there a missing piece that I should know of? I also read: >> Digital circuits are the most common mechanical representation of Boolean algebra and are the basis of all digital computers. They can also be used to process digital information without being connected up as a computer. Such circuits are referred to as "random logic". << In other words, digital circuits = "random logic." Wonder if I can say Boolean is random logic? Don't want to bother with DeMorgan Theorem as long as I know how to write my formula. Thank you for reading. Epinn For those that might be following: http://www.j-walk.com/ss/help/maillist.htm I am not a member so I don't know how it works. Biff I have one more interested party now. Can you tell me if I add posts to my original thread in Newuser, will they show up in ListServ? Epinn Saw it but didn't study it. I also noticed that Don raised in on the ListServ, but again I haven't followed it. -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Epinn" <someone@example.com.NO_SPAM> wrote in message news:uhKRXCaEHHA.1304@TK2MSFTNGP02.phx.gbl... Thank you and I'll "get on with it." Have you read my latest discovery (11/25/2006 same forum)? Biff and Don were surprised and Don said he would refer the thread to the L & G lists which I have no idea what the lists are. I'll do my best to give Boolean a rest. Epinn In computer programming, True is -1, all bits set, False is 0, all bits unset. Excel, as against VBA, for some reason decided that True was 1. And to compound the difference, they decided any value other than 0 was True. After a while, you stop worrying/wondering why, you just accept it as a fact and get on with it. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Epinn" <someone@example.com.NO_SPAM> wrote in message news:uFsFwZPEHHA.3396@TK2MSFTNGP02.phx.gbl... I read the following and have a couple of questions. >> A Boolean logical input or output always takes one of two logic levels. These logic levels can go by many names including: on / off, high (H) / low (L), one (1) / zero (0), true (T) / false (F), positive / negative, positive / ground, open circuit / close circuit, potential difference / no difference, yes / no. In computer science, the Boolean datatype, sometimes called the logical datatype, is a primitive datatype having two values: one and zero (sometimes called true and false). It is the special case of a binary numeric datatype of only one digit, or bit..... This datatype is used in Boolean and other operations such as and (AND, &, *), or (OR, |, +), exclusive or/not equivalent (xor, NEQV, ^), equal (EQV, =, ==) and not (NOT, ~, !) which correspond to some of the operations of Boolean algebra and arithmetic. << I have no problem understanding the above and I always know that TRUE is 1 and FALSE is 0 *theoretically*. However, I have discovered that in Excel, 0 is FALSE and anything other than 0 including negative values is TRUE and not just 1 is TRUE. Is there a missing piece that I should know of? I also read: >> Digital circuits are the most common mechanical representation of Boolean algebra and are the basis of all digital computers. They can also be used to process digital information without being connected up as a computer. Such circuits are referred to as "random logic". << In other words, digital circuits = "random logic." Wonder if I can say Boolean is random logic? Don't want to bother with DeMorgan Theorem as long as I know how to write my formula. Thank you for reading. Epinn No it won't. ListServ is an independent forum and the posts here do not crossover (thank-goodness!) -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) I have one more interested party now. Can you tell me if I add posts to my original thread in Newuser, will they show up in ListServ? Epinn Saw it but didn't study it. I also noticed that Don raised in on the ListServ, but again I haven't followed it. -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Epinn" <someone@example.com.NO_SPAM> wrote in message news:uhKRXCaEHHA.1304@TK2MSFTNGP02.phx.gbl... Thank you and I'll "get on with it." Have you read my latest discovery (11/25/2006 same forum)? Biff and Don were surprised and Don said he would refer the thread to the L & G lists which I have no idea what the lists are. I'll do my best to give Boolean a rest. Epinn In computer programming, True is -1, all bits set, False is 0, all bits unset. Excel, as against VBA, for some reason decided that True was 1. And to compound the difference, they decided any value other than 0 was True. After a while, you stop worrying/wondering why, you just accept it as a fact and get on with it. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Epinn" <someone@example.com.NO_SPAM> wrote in message news:uFsFwZPEHHA.3396@TK2MSFTNGP02.phx.gbl... I read the following and have a couple of questions. >> A Boolean logical input or output always takes one of two logic levels. These logic levels can go by many names including: on / off, high (H) / low (L), one (1) / zero (0), true (T) / false (F), positive / negative, positive / ground, open circuit / close circuit, potential difference / no difference, yes / no. In computer science, the Boolean datatype, sometimes called the logical datatype, is a primitive datatype having two values: one and zero (sometimes called true and false). It is the special case of a binary numeric datatype of only one digit, or bit..... This datatype is used in Boolean and other operations such as and (AND, &, *), or (OR, |, +), exclusive or/not equivalent (xor, NEQV, ^), equal (EQV, =, ==) and not (NOT, ~, !) which correspond to some of the operations of Boolean algebra and arithmetic. << I have no problem understanding the above and I always know that TRUE is 1 and FALSE is 0 *theoretically*. However, I have discovered that in Excel, 0 is FALSE and anything other than 0 including negative values is TRUE and not just 1 is TRUE. Is there a missing piece that I should know of? I also read: >> Digital circuits are the most common mechanical representation of Boolean algebra and are the basis of all digital computers. They can also be used to process digital information without being connected up as a computer. Such circuits are referred to as "random logic". << In other words, digital circuits = "random logic." Wonder if I can say Boolean is random logic? Don't want to bother with DeMorgan Theorem as long as I know how to write my formula. Thank you for reading. Epinn |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.