This quick tip determines whether Excel sees the numbers one and zero as true and false.
In computing terms, one and zero are bits. And, bits are binary numbers. In fact, a bit is short for binary digit. Therefore, we can easily perform logical operations with these two numbers.
Fortunately, Excel has a few logical operators that will allow you to perform all types of tests. We will use the AND function to test this theory.
Follow the steps below to test how Excel views zero and one in logic.
After you press Enter, you should have a result from Excel
Our function resulted in FALSE. What if you change 0 to 1? See the results below.
When we change 0 to 1, Excel calculates the function AND as TRUE. How do you like that?
As a result of our tests, we can determine that Excel sees 1 as TRUE and 0 as FALSE.
Instead of using AND, try the OR function. Just replace AND with OR. Do you get the same results?
Or, you can try the IF function, like =IF(A1,TRUE,FALSE). Of course, you will replace the old function with the IF function.
The numbers one and zero are also true and false
by Excel Effects :: October 21, 2020