Learn Microsoft Excel Online Free
This post will guide you how to use Excel TRUE function with syntax and examples in Microsoft excel. Description The Excel TRUE function return the logical value TRUE. And you can use the TRUE function when you want to return the TRUE value. For example, the formula: =IF(B1>5, TRUE()). The TRUE function is a build-in… read more »
This post will guide you how to use Excel OR function with syntax and examples in Microsoft excel. Description The Excel OR function used to test multiple conditions and returns TRUE if any of the conditions are TRUE. Otherwise, it will return FALSE. You can use the OR function as the logical test inside the… read more »
This post will guide you how to use Excel NOT function with syntax and examples in Microsoft excel. Description The Excel NOT function returns the opposite of a given logical or Boolean value. For example, if you supplied with the value TRUE, the NOT function will return FALSE; If you supplied with the value FALSE,… read more »
If you want to check the value in one cell if it is blank or empty cell, then you can use IF function in combination with ISBLANK function or logical operator (equal to) in excel. Excel IF function check if the cell is blank Let’s see the generic IF formula with ISBLANK function and Logical… read more »
If you have a list of dates and then want to compare to these dates with a specified date to check if those dates is greater than or less than that specified date. You can use the IF function in combination with logical operators and DATEVALUE function in Microsoft excel. Excel IF function combining with… read more »
Normally, If you want to write an IF formula for text values in combining with the below two logical operators in excel, such as: “equal to” or “not equal to”. Excel IF function check if a cell contains text(case-insensitive) By default, IF function is case-insensitive in excel. It means that the logical text for text values… read more »
Normally, If you want to write an IF formula for numbers in combining with the logical operators in excel, such as: greater than, less than, greater than or equal to, less than or equal to, equal to, not equal to.etc. The generic IF formula with logical operator for number values is as below: =IF(B1>10,”good”,”bad”) Excel… read more »
This post will guide you how to use excel if formula with NOT logical function in Microsoft excel. NOT Logical Function The syntax of NOT logical function is as follow: =NOT(logical_value) The NOT logical function will return the reversed logical value. If the logical_value is TRUE, then FALSE is returned. If the logical_value is FALSE,… read more »
This post will guide you how to use if function with “greater than”, “greater than or equal to”, ”less than” and “less than or equal to” logical operators in excel. Greater than, Greater than or equal to, Less than, less than or equal to The “greater than”(>)operator will compare the size of two different values in… read more »
If you want to test the result of cells based on several sets of multiple test conditions, you can use the IF function with the AND and OR functions at a time. Assuming that you have the following test logic to check the exam scores: Logic test1: 60<=B1<=70 Logic test2: 60<=C1<=70 If any of the above conditions… read more »
This post will guide you how to use IF function combining with OR logical function in Excel. If you want to check if one of several conditions is met in your excel workbook, if the test is TRUE, then you can take certain action. You can use the IF function combining with OR function to… read more »
This post will guide you how to use IF function combining with AND logical function in Excel. If you want to check if a value in cell match two or more conditions at the same time, if the test is TRUE, then you can take certain action. You can use the IF function combining with… read more »
The “Equal to” logical operator can be used to compare the below data types, such as: text string, numbers, dates, Booleans. This section will guide you how to use “equal to” logical operator in excel IF formula with text string value and dates value. Formula example Description =IF(A1=B1,“TRUE”,”FALSE”) Returns TRUE if a value in cell… read more »
Many people usually asked that how to write an excel nested if statements based on multiple ranges of cells to return different values in a cell? How to nested if statement using date ranges? How to use nested if statement between different values in excel 2013 or 2016? Nested IF statements based on multiple ranges Nested… read more »
This tutorial will guide you how to use nested Excel IF function (include multiple If statements in excel formula) with syntax and provide about 15 nested IF formula examples with the detailed explanation in Microsoft excel. Nested If function Description Nested If Function Syntax Examples of Nested IF function in Excel Nested If Functions(Statements) Order… read more »
This post will guide you how to use Excel IFNA function with syntax and examples in Microsoft excel. Description The Excel IFNA function returns an alternate value you specify if a formula results in an #N/A error, or returns the result of the formula. The IFNA function is a build-in function in Microsoft Excel and it… read more »
This post will guide you how to use Excel IFERROR function with syntax and examples in Microsoft excel. Description The Excel IFERROR function returns an alternate value you specify if a formula results in an error, or returns the result of the formula. The IFERROR function is a build-in function in Microsoft Excel and it is… read more »
This post will guide you how to use Excel IF function with syntax and examples in Microsoft excel. Excel IF function Description Excel IF function Syntax Nested IF statements Excel Logical operators Frequently Asked Questions Related Functions Excel IF Formula Examples Description The Excel IF function perform a logical test to return one value if the… read more »
This post will guide you how to use Excel FALSE function with syntax and examples in Microsoft excel. Description The Excel FALSE function returns the logical value “FALSE”. The FALSE function is a build-in function in Microsoft Excel and it is categorized as a Logical Function. The FALSE function is available in Excel 2016, Excel 2013, Excel… read more »
This post will guide you how to use Excel AND function with syntax and examples in Microsoft excel. Description The Excel AND function returns TRUE if all of arguments are TRUE, and it returns FALSE if any of arguments are FALSE. The AND function is a build-in function in Microsoft Excel and it is categorized as… read more »
