More on Boolean

[Epinn]

I read the following and have a couple of questions.
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:

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

 

[Gary''s Student]

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

 

[Bob Phillips]

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.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:
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

 

[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.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

I read the following and have a couple of questions.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:
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

 

[Bob Phillips]

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)

I read the following and have a couple of questions.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:
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

 

[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

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.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:
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

 

[T. Valko]

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)

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)

I read the following and have a couple of questions.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:
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

 

[Bob Phillips]

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)

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)

I read the following and have a couple of questions.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:
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