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



--
Gary's Student


"Epinn" wrote:

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

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

"Bob Phillips" wrote in message ...
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" wrote in message
...
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)

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

"Bob Phillips" wrote in message ...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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

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

"Bob Phillips" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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)

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

"Bob Phillips" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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