Logical Functions in Excel

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 IFNA Function in Excel (2 Examples)

The IFNA function is primarily used to handle the #N/A errors. It returns a specific value as per your instruction if such #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 (5 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 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 ...

5 Excel Hacks You Never Knew

Genius tips to help you unlock Excel's hidden features

FREE EMAIL BONUS

ExcelDemy
Logo