The TRUE and FALSE formulas are rarely used Excel functions. The reason for less use of these functions is that there are many alternative formulas to TRUE and FALSE. However, it is interesting to know that the TRUE function and FALSE function are very useful to cater to the requirements of different versions of excel. These functions are mainly used for compatibility with other excel or spreadsheet versions. Show In this blog, we would deep dive into the following aspects of TRUE and FALSE excel formulas.
Here we go đ Objective of TRUE and FALSE Excel FunctionsMany a time, I have received a common question from many excel users â âWhat is the use of these two uncommon excel functions â TRUE and FALSEâ. The answer lies below đ The =TRUE() formula simply returns the logical value âTRUEâ and similarly, the =FALSE() formula returns the logical value âFALSEâ in Excel. Syntax and ArgumentsFollowing are the syntax of the two functions: =TRUE() =FALSE() These two functions does not hold any input argument, i.e. these are empty parenthesis functions. Example of TRUE and FALSE Excel FunctionsLet me first make you understand how to use the TRUE and FALSE excel functions and what would it return. Simply type the formula =TRUE() and =FALSE() in an excel cell and press Enter. As a result, you would notice that excel returns the values â âTRUEâ and âFALSEâ respectively. See the image below: Using this formula individually does not make sense. Moreover, this formula is combined with other logical functions like the IF function in Excel to get the result. See the below example: =IF(A2=âFemaleâ,TRUE(),FALSE()) In the above example, the IF function would return the value TRUE, if the value in cell B4 is âFemaleâ otherwise it would return FALSE. Thus, if the condition of the IF argument does not meet, then it simply returns the text TRUE, otherwise FALSE. Do Not Miss These Points
Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2019 for Mac Excel 2016 Excel 2016 for Mac Excel 2013 Excel 2010 Excel 2007 Excel for Mac 2011 Excel Starter 2010 More...Less This article describes the formula syntax and usage of the TRUE function in Microsoft Excel.
Note: The TRUE function is provided primarily for compatibility with other spreadsheet programs. Returns the logical value TRUE. You can use this function when you want to return the value TRUE based on a condition. For example: =IF(A1=1,TRUE()) You can also enter the value TRUE directly into cells and formulas without using this function. For example: =IF(A1=1,TRUE) If the condition is met, Excel returns TRUE in both examples. If the condition is not met, Excel returns FALSE in both examples. TRUE() The TRUE function syntax has no arguments. IF function Create conditional formulas Logical functions (reference)
Microsoft Excel is an excellent tool often used to keep track of data and other useful records. Among the various capabilities entailed in excel is the use of function and not only so but those that are conditional by nature. This conditional function operates under the same principle of Boolean logic. In our case, instead of 1's and O's, we have True and False. This type of formulae is very powerful in its simplicity. For example, you might be a class teacher. You may need to calculate and see the student performance in relation to the mean score. Having noticed the importance of the true and false, it time dive into its use!!! How to use the true and false function in Microsoft Excel 1. Have a list of data in place to compare.. as in my case, the data is below In our case, with the data provided, we will be checking those that have attained the mean mark, which is 50. With those who have attained 50 and above, the remark would display true, and those that are 49 and below False will be what we expect. 2. In cell C3, write the conditional function If (B3>= 50, True(), False()) In our table, since the first column B3, Kengere is above average, the outcome will be true 3. Repeat the same process in the remaining cells Method 2 Excel comes with inbuilt true and false functions. For example, if you type =TRUE() a TRUE value will be returned. Alternatively if you type =FALSE() a false value will be returned However, you don't have to use these functions under normal circumstances. In the above table, TRUE represents 1 while False represents 0. Knowing that we can apply it to make calculations. The formula multiplies the result of TRUE by 25 and vice versa Conclusion That was simple, is it so? Hoping the guide has been simple and useful as you notice how powerful a tool the true and false function is, and advancing your knowledge in its application will only make Excel desirable and easy to use |