Excel Functions Archives

Excel ENGINEERING Functions; 50++ Functions: 8 Methods

Jul 6, 2024

Method 1 - Using the CONVERT Function to Convert Between Units of Measurement To convert a gram unit into a pound mass unit, follow the steps below: ...

Excel ENGINEERING Functions; 50++ Functions: 8 Methods

How to Use Excel String Functions (Examples of 17 Functions)

Jun 17, 2024

Function 1 – TEXT Function Syntax: =TEXT(value, format_text) Arguments Explanation: Argument Required/Optional ...

How to Use Excel String Functions (Examples of 17 Functions)

Excel Date Functions – A Complete Guide

Jul 5, 2024

This is an overview. . Download Practice Workbook Download the workbook here. Excel Date Functions.xlsx 1 - Insert ...

Using the Excel SUMIFS Function with Multiple Criteria – 5 Examples

Jul 3, 2024

With the SUMIFS function you can add numbers that fulfill more than one condition. This is an overview: Download Practice Workbook ...

Using the Excel SUMIFS Function with Multiple Criteria – 5 Examples

COUNTIF Multiple Criteria (All Things You Need to Know)

Jul 3, 2024

The image below is an overview of using the COUNTIF function with multiple criteria in Excel. Download Practice Workbook COUNTIF ...

COUNTIF Multiple Criteria (All Things You Need to Know)

Issues with VLOOKUP

Dec 26, 2023

In this article, we are going to see how we can resolve the issues with VLOOKUP in the most efficient manner possible. Being one of the most popular ...

How to VLOOKUP a Range in Excel – 7 Examples

Jun 20, 2024

The VLOOKUP function checks if data belongs to a range. Download Practice Workbook Download the worksheet. Performing VLOOKUP in ...

How to VLOOKUP a Range in Excel – 7 Examples

190+ Most Used Excel Functions List by Category

Jun 17, 2024

70 Most Popular & Common Excel Functions by Alphabetical Order Function Name Objective AND Checks whether ...

190+ Most Used Excel Functions List by Category

Top Financial Functions in Excel (15+ Functions)

Feb 25, 2024

Excel contains different financial functions designed to perform different financial calculations and analyses easily. Financial functions can ...

Top Financial Functions in Excel (15+ Functions)

Logical Functions in Excel

Feb 11, 2024

Logical Functions in Excel IF AND OR NOT IFERROR IFNA XOR << Go Back to Excel Function Categories | Excel ...

Table Array in Excel (Create, Use and Fix Issues)

Jul 6, 2024

The table below is an overview of table array to lookup values in Excel. Download Practice Workbook Table Array.xlsx What Is ...

Table Array in Excel (Create, Use and Fix Issues)

How to Use the CONCAT Function in Excel – 7 Examples

Jun 13, 2024

The CONCAT function can be used to concatenate different values and ranges of cells. It can handle dynamic data from different sources. ...

How to Use the CONCAT Function in Excel – 7 Examples

IF with ISERROR Function in Excel: 4 Practical Examples

Jul 8, 2024

Here's an overview of using the IF and ISERROR functions to check a car's unit price depending on the amount of available stock. What Is ...

IF with ISERROR Function in Excel: 4 Practical Examples

Excel SUMIF Not Equal Criteria: 5 Suitable Examples

May 29, 2024

Method 1 - Calculating Sum with Numeric Not Equal Single Criteria Use the following formula in a cell of your worksheet. =SUMIF(E5:E17, ...

Excel SUMIF Not Equal Criteria: 5 Suitable Examples

Sum If Greater Than and Less Than Cell Value in Excel

May 21, 2024

Method 1 - Sum If Greater Than and Less Than from Same Value 1.1 Applying SUMIF Function for Greater Than and Less Than from Same Value You have to ...