Logical Functions in Excel

How to Use AND and OR Functions in Excel (3 Practical Examples)

While working in Excel, we often use the AND function. Sometimes we also use the OR function. There are times when we might need to use both the AND ...

How to Use Excel SWITCH Function (5 Examples)

To switch a particular value with the value of your choice you can use the Excel SWITCH function. It is a comparison and referencing function in ...

How to Use Excel XOR Function (5 Suitable Examples)

Excel XOR function is an exclusive OR function. The XOR function returns TRUE if an odd number of logical statements are TRUE and FALSE if an even ...

How to Use Excel IFNA Function (5 Suitable Examples)

Excel IFNA function is primarily used to handle the #N/A errors. It returns a specific value as per your instruction if such a #N/A error occurs; ...

How to Use IFERROR Function in Excel (4 Practical Examples)

In this tutorial, I am going to show you 4 practical examples of how to use the IFERROR function in Excel. You can use these methods even in large ...

How to Use IF Function in Excel (8 Suitable Examples)

In Microsoft Excel, the IF function is used to check if a condition is met and then the defined statements will be shown based on the given ...

How to Use NOT Function in Excel (8 Useful Examples)

The NOT function in Excel returns a logically opposite value. In this article, you’ll learn to use this function and also discuss its application ...

How to Use IFS Function in Excel (3 Examples)

While working in Microsoft Excel, there are various formulas to make our work easier. The IFS formula is one of them. It has a wide range of ...

How to Use AND Function in Excel (7 Suitable Examples)

In Microsoft Excel, AND is one of the most frequently used functions and the AND function is applied to check for logical tests under different ...

How to Use OR Function in Excel (4 Ideal Examples)

Fortunately, there are a number of functions in Excel to perform various logical operations easily and swiftly. Today we are going to show you how to ...

How to Use TRUE Function in Excel (10 Ideal Examples)

The TRUE function has a special type of compatibility in returning results based on logical conditions. In this article, I’ll discuss how to use the ...

How to Use FALSE Function in Excel (7 Easy Examples)

The FALSE function in Excel is one of the logical functions in Excel which gives FALSE as output. Using this function, we can declare the cell value ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo