![]() That means that if we multiply TRUE by any number x, we should get x as an output. That's a bit confusing when we think about it, so let's take a look at a couple of examples to help understand what's going on:įirst, the TRUE function in Excel is equivalent to the number 1 - they can be used interchangably. In Excel, the function TRUE is equivalent to the number 1, and the function FALSE is equal to the number 0. Here's one more interesting tip about the TRUE and FALSE functions: they're also numbers. Let's see what happens when we try to equate the TRUE and FALSE functions: =( TRUE= FALSE)Īs you might expect, TRUE and FALSE are not equal to each other, so this formula evaluates as FALSE. The previous code block returns TRUE because the TRUE function is, indeed equal to itself. We can also use Excel's TRUE and FALSE functions within logical statements of their own. No parentheses required! TRUE and FALSE within logical statements ![]() Take a look at the following examples: = TRUE ![]() Since the TRUE and FALSE functions are used so commonly within Excel, Microsoft has provided us with a handy shortcut: we can leave off the parentheses after the functions, and they'll work just the same. It may not make sense just yet why you would want to set a cell value to simply TRUE or FALSE, but this will come in handy later on when we start to take a look at IF statements in Excel. Take, for example, the following simple formula, which just fills a cell with the default TRUE value: = TRUE() We can also use TRUE and FALSE on their own, without having to evaluate the truth of a particular statement.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |