Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
In Excel, can Boolean logic be applied to conditional formatting? | Excel Worksheet Functions | |||
Need some comments on my Utility_Move class module. | Excel Worksheet Functions | |||
Boolean 0/1 instead of True/False | Excel Discussion (Misc queries) | |||
SUMIF boolean? | Excel Worksheet Functions | |||
how can I insert a macro into a boolean statement | Excel Worksheet Functions |