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