OR Function

How to Use Excel ISBLANK to Identify Blanks in Range

Sometimes, you need to do something with a cell if it is not blank. If you are searching for a Microsoft Excel function that checks if a cell is ...

How to Use IF-THEN Statements with Text in Excel (7 Examples)

Sometimes you may need to use some combination of functions in Excel for searching a particular text or returning the answer as text. So, if you are ...

Check If Cell Contains Text Then Return Value with Multiple Conditions in Excel

Looking for ways to check if a cell contains text and then return value with multiple conditions in Excel? Then, this is the right place for you. ...

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 Create an Attendance Roster in Excel (with Easy Steps)

In this article, I will show you how to create an attendance roster in Excel. As we know, Excel is a very handy tool for keeping track of employees’ ...

How to Create Test Cases for ATM Machine in Excel Sheet

In this article, you will learn about three quick steps on how to prepare test cases for the ATM machine in the Excel sheet. We will be using ...

Prepare Test Cases for Gmail in Excel Sheet (with Easy Steps)

In this article, you will learn about four quick steps on how to prepare test cases for Gmail in the Excel sheet. We will be using Microsoft 365 to ...

How to Create Test Cases for Registration Form in Excel Sheet

In this article, you will learn about three quick steps on how to create test cases for the registration form in the Excel sheet. We will be using ...

Create Test Cases for Login Page in Excel Sheet (with Easy Steps)

In this article, you will learn about three quick steps on how to create test cases for the login page in the Excel sheet. We will be using Microsoft ...

Test Cases for Banking Application in Excel Sheet (4 Easy Steps)

In this article, you will learn about four quick steps on how to prepare test cases for the banking application in the Excel sheet. We will be using ...

How to Create a Conditional Formula in Excel (5 Easy Ways)

You can construct a conditional formula to conduct a computation when a cell contains a particular value. If the condition is true, a conditional ...

Excel COUNTIF to Count Cell That Contains Text from Another Cell

The COUNTIF function counts for specific criteria. You may want to count your text dataset. The COUNTIF function helps you out in this situation. ...

How to Compare 2 CSV Files in Excel (6 Easy Ways)

Microsoft Excel is a powerful software. We can perform numerous operations on our datasets using the tools and features of Excel. Sometimes, we have ...

How to Apply Borders in Excel with Conditional Formatting

This article illustrates how to apply conditional formatting borders in excel. Conditional formatting is one of the most useful features in excel. ...

How to Use AND Function in Excel with Text (8 Easy Examples)

In Excel, you can use the AND function to test whether several conditions are true or false. Combining text with the AND function can particularly ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo