IF Function

Lookup and Return Multiple Values Concatenated into One Cell in Excel

In Microsoft Excel, there are a number of suitable techniques to lookup a criterion and then return multiple values concatenated into one cell based ...

How to Write Greater Than or Equal To in Excel IF Function

The IF function in Excel is a logical function where you may need to use various comparison operators: equal, not equal, greater than, less than, and ...

How to Use MAX IF Function in Excel

While working in excel, we need to find the maximum value under a given condition. The combination of the MAX function and IF function can help you ...

How to Use Excel IF Function with Range of Values

IF is one of the most useful and widely used functions of Excel. Today I will be showing how to use this IF function with a wide range of values, ...

VLOOKUP to Return Multiple Values Horizontally in Excel

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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

ExcelDemy
Logo