Excel Functions

How to Use the VBA Trim Function in Excel – 5 Examples

This is an overview. The VBA TRIM Function Summary The Trim function in VBA removes the leading and trailing spaces from a ...

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 the ISTEXT Function in Excel (8 Examples)

Excel ISTEXT Function: Syntax and Argument In this section, we will explain the syntax and argument of the ISTEXT function. ISTEXT Function of ...

How to Use the ISNA Function in Excel – 3 Examples

This is an overview. The ISNA Function in Excel The ISNA function is an INFORMATION function in Excel. It checks whether a cell contains ...

How to Use ISEVEN Function in Excel (2 Suitable Examples)

Today I will be showing how you can decide whether a number is even or odd using the ISEVEN function of Excel. This function helps us to define even ...

How to Use ISODD Function in Excel (4 Suitable 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 the ISNUMBER Function in Excel (7 Methods)

The ISNUMBER function in Microsoft Excel is commonly used to determine whether a given argument contains a numerical value. The above ...

How to Use the TRIM Function in Excel (7 Examples)

Introduction to the Excel TRIM Function The Excel TRIM function is categorized under the TEXT functions. It removes the extra spaces from a text ...

How to Use ISBLANK Function in Excel (3 Examples)

In this article, we will discuss Excel's ISBLANK function, as in the following gif. Excel ISBLANK Function: Syntax and Argument ISBLANK ...

How to Use the SUBSTITUTE Function in Excel (7 Examples)

In this article, we will demonstrate some uses of the SUBSTITUTE function with examples. Excel SUBSTITUTE Function: Quick View ...

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

If you are looking for how to use the ISERROR function in Excel then you are in the right place. For ignoring any type of calculation error, it is ...

How to Use UPPER Function in Excel (4 Examples)

In Microsoft Excel, the UPPER function is generally used to convert all the letters in a string of text to block ones. In this article, you’ll get to ...

How to Use the SEARCH Function in Excel – 3 Examples

This is an overview of the SEARCH function. Introduction to the SEARCH Function Summary The SEARCH function returns the number of ...

How to Use Excel PROPER Function (2 Ideal Examples)

Fortunately, there are several text functions in Excel to help you perform your desired tasks easily and swiftly. Today, we are going to show you how ...

How to Use TEXT Function in Excel (10 Examples)

Here's an overview of a few applications of the TEXT function in Excel. Introduction to the TEXT Function Function Objective: ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo