OR Function Archives

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

Jan 31, 2023 Excel Formulas

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

Jan 30, 2023 Excel Formulas

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)

Jan 4, 2023 Excel Formulas

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)

Jan 4, 2023 Excel Basics

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

Jan 4, 2023 Advanced Excel

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)

Jan 4, 2023 Excel Basics

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

Jan 4, 2023 Excel Basics

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)

Jan 3, 2023 Excel Basics

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)

Jan 3, 2023 Advanced Excel 2

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)

Dec 28, 2022 Excel Basics

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

Dec 27, 2022 Excel Formulas

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)

Dec 26, 2022 Advanced Excel

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

Dec 21, 2022 Excel Basics

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 with Text in Excel (4 Simple Methods)

Dec 19, 2022 Excel Formulas

While working in Microsoft Excel sometimes we need to use AND function. But when it comes to using AND function with texts, then it might seem ...

How to Remove Comma Between Numbers in Excel

Dec 18, 2022 Excel Formulas

Commas have several uses while dealing with spreadsheets in Excel. For example, they improve the readability of numbers. However, there may be ...