Excel Formulas Archives

How to Audit Formulas Using Excel Auditing Tools – 7 Tools

Aug 4, 2024

The following is an overview: Download Practice Workbook Audit Formulas.xlsx The sample dataset showcases Principal Amount, ...

How to Audit Formulas Using Excel Auditing Tools – 7 Tools

Calculate Percentage with Criteria in Excel (2 Useful Examples)

Jun 10, 2024

Method 1 - Use the IF Function to Calculate a Percentage with Criteria in Excel Consider the following dataset with the sales volume of some ...

Calculate Percentage with Criteria in Excel (2 Useful Examples)

Excel Average Formula Examples

Nov 11, 2025

In this Excel tutorial, you will learn various examples of how to apply formula to calculate average in Excel. We will discuss how to calculate the ...

Conditional Average in Excel (Complete Guide)

Aug 4, 2024

Conditional averages involve calculating the average of a subset of data that meets specific criteria. In this Excel tutorial, we will demonstrate ...

Conditional Average in Excel (Complete Guide)

Selling Price Formula Excel

Nov 11, 2025

Selling Price Formula Excel: Knowledge Hub How to Calculate Retail Price in Excel How to Calculate Selling Price in Excel Calculate the ...

How to Calculate Average in Excel (Ultimate Guide)

Aug 4, 2024

In this article, we will comprehensively cover calculating the average in Excel, particularly using the AVERAGE function to find the average of ...

How to Calculate Average in Excel (Ultimate Guide)

How to Calculate Ratio in Excel: 4 Methods

Jul 3, 2024

Method 1 - Use Simple Division to Calculate Ratio Select the cell where you want to calculate the ratio >> Write the following formula: ...

How to Calculate Ratio in Excel: 4 Methods

How to Divide in Excel (Using Functions and Features)

May 28, 2024

We used Microsoft 365 to prepare this article. You can apply the operations in Excel's previous versions with the exception of the QUOTIENT function, ...

How to Divide in Excel (Using Functions and Features)

Excel Add and Subtract (Complete Guideline)

Jul 28, 2024

Here's a simple overview of using common functions and operators to add and subtract ranges. Download the Practice Workbook Excel Add ...

Excel Add and Subtract (Complete Guideline)

How to Subtract in Excel: 11 Different Methods

Jul 5, 2024

Method 1 - How to Subtract Two or More Numbers Manually in Excel Write the amounts like the following formula in cell G5 with the Minus (-) sign ...

How to Subtract in Excel: 11 Different Methods

Weighted Average Excel (All Things to Know)

Nov 11, 2025

By following this article, you will learn to calculate weighted average in Excel. We’ll use a simple formula, SUM function, and the combination of ...

Weighted Average Excel (All Things to Know)

AutoSum in Excel (Complete Guideline)

Jul 5, 2024

To apply the AutoSum feature: Go to the Home tab > click AutoSum feature under the Editing group. This will insert the SUM formula ...

How to Sum in Excel (All Things You Need to Know)

Jul 28, 2024

Here's the simplest use of the SUM function to sum a range of values. Download the Practice Workbook Sum in Excel.xlsx ...

How to Sum in Excel (All Things You Need to Know)

How to Calculate in Excel (5 Useful Techniques)

Nov 11, 2025

The article elaborates the addition, subtraction, multiplication, division, exponentiation, and so on for how to calculate in Excel. The application ...

How to Calculate in Excel (5 Useful Techniques)

Excel Union (Using Operator, Application.Union Method in VBA)

Nov 11, 2025

Excel's union operation is a potent tool that lets you combine data from various ranges into a single object. Utilizing the Union operator and the ...