IF Function Archives - Page 3 of 9

VLOOKUP to Return Multiple Values Horizontally in Excel

Nov 10, 2021 Excel Formulas 2

In Microsoft Excel, there are a few options to VLOOKUP and return multiple values horizontally. Although the VLOOKUP function itself is not able to ...

VLOOKUP Max of Multiple Values (With Alternative)

Nov 10, 2021 Excel Formulas

MS Excel’s VLOOKUP function is used when we need to find things in a table or in a range by row. It makes our task easy in terms of searching for ...

How to Use SEQUENCE Function in Excel (16 Examples)

Nov 2, 2021 Excel Functions 2

In Microsoft Excel, the SEQUENCE function is used to generate a sequence of numeric values in different formats. In this article, you'll learn how ...

Find Matches or Duplicate Values in Excel (8 Ways)

Oct 26, 2021 Excel Basics

In Microsoft Excel, there are several suitable methods to find matches or duplicate values with formulas or VBA. You can extract data based on the ...

How to Sort Two Columns in Excel to Match (Both Exact and Partial Match)

Nov 1, 2021 Excel Formulas

While working in Excel, we often have to work with columns that are almost the same, and sometimes exactly the same. Today I will be showing how you ...

How to Use ISLOGICAL Function in Excel (4 Examples)

Nov 11, 2021 Excel Functions

In Microsoft Excel, the ISLOGICAL function is generally used to check whether a given argument contains a boolean value (TRUE or FALSE) or not. In ...

How to Use ISTEXT Function in Excel (3 Examples)

Nov 11, 2021 Excel Formulas

While working in Excel, we have to come across a lot of data types, like text values, numbers, boolean values, blank cells, etc. Most of the time ...

How to use ISNA function in Excel (4 Examples)

Nov 11, 2021 Excel Functions

Excel provides several information functions to provide you the necessary information and help you perform your desired tasks easily and swiftly. ...

How to Use ISEVEN Function in Excel (2 Examples)

Nov 11, 2021 Excel Formulas

Today I will be showing how you can decide whether a number is even or odd using the ISEVEN function of Excel. Excel ISEVEN Function (Quick View) ...

How to Use ISODD Function in Excel (With 4 Examples)

Nov 11, 2021 Excel Formulas

The ISODD is one of the Excel information functions. It is a reference function that assists to show if a given number is odd or not. This article ...

How to Use ISNUMBER Function in Excel (7 Examples)

Nov 11, 2021 Excel Functions

In Microsoft Excel, the ISNUMBER function is generally used to check whether a given argument contains a numerical value or not. In this article, ...

How to Use ISBLANK Function in Excel (2 Examples)

Nov 11, 2021 Excel Formulas

Today I will be showing how you can check whether a cell is empty or not using the ISBLANK function of Excel. Excel ISBLANK Function (Quick View) ...

How to Use ISERROR Function in Excel (With 5 Examples)

Nov 11, 2021 Excel Formulas

For ignoring any type of calculation error, it is better to use exception handling. MS Excel provides an ISERROR function for this purpose. This ...

How to Use SEARCH Function in Excel (3 Examples)

Nov 11, 2021 Excel Formulas

Today I will be showing how you can use the SEARCH function of Excel to search for a particular text within a given string. SEARCH Function of ...

How to use MAX function in Excel (6 Examples)

Nov 11, 2021 Excel Functions

There are several statistical functions in Excel to help you perform your desired tasks easily and swiftly. Today we are going to show you how to use ...