Excel Formulas Archives - Page 73 of 149

How to Convert Millimeters (mm) to Feet (ft) and Inches (in) in Excel – 4 Methods

Aug 9, 2024

The dataset contains people's names and their height in mm. To convert the height to feet and inches: Method 1 - Using the Excel CONVERT ...

How to Convert Millimeters (mm) to Feet (ft) and Inches (in) in Excel – 4 Methods

How to Calculate Sales Growth over 5 Years in Excel (3 Ideal Examples)

Nov 11, 2025

Business sectors preserve their necessary information in Excel. They have to perform various operations according to their requirements. The sales ...

How to Calculate Sales Growth over 5 Years in Excel (3 Ideal Examples)

How to Calculate Peak Area in Excel (2 Effective Methods)

Jul 15, 2024

The sample dataset is a graphical representation of the equation y=sinx ranging from 0 to pi. The graph has a peak at sin (pi/2) where the ...

How to Calculate Peak Area in Excel (2 Effective Methods)

How to Calculate Range in Excel (5 Handy Methods)

Jul 15, 2024

We have made a dataset of Sales of Shoes and Bags in 2021 at different stores. We'll use it to apply various range functions. Method 1 - ...

How to Calculate Range in Excel (5 Handy Methods)

How to Calculate Selling Price Per Unit in Excel (3 Easy Ways)

Nov 11, 2025

Looking for ways to know how to calculate the selling price per unit in Excel? Then, this is the right place for you. In regular life, we have to ...

How to Calculate Selling Price Per Unit in Excel (3 Easy Ways)

How to Calculate Age in Excel from ID Number (4 Quick Methods)

Apr 25, 2024

Let’s consider the following dataset (in B4:C14) with people's Names and their ID Numbers. The first 6 digits in ID Numbers represent the date of ...

How to Calculate Age in Excel from ID Number (4 Quick Methods)

How to Calculate Selling Price in Excel (4 Easy Methods)

Jun 16, 2024

Arithmetic Formula to Calculate Selling Price Before calculating a selling price in Excel, it's important to know the appropriate formulas. If we ...

How to Calculate Selling Price in Excel (4 Easy Methods)

How to Calculate Portfolio Variance in Excel (3 Methods)

Jul 22, 2024

What Is Portfolio Variance? Portfolio variance is a statistical measure in modern investment theory. It quantifies the dispersion of actual returns ...

How to Calculate Portfolio Variance in Excel (3 Methods)

How to Use Ageing Formula for 30 60 90 Days in Excel (5 Effective Ways)

Jun 24, 2024

Method 1 - Using an Aging Formula for 30, 60, or 90 Days with Conditional Formatting The following table has Customer, Project, and Date columns. We ...

How to Use Ageing Formula for 30 60 90 Days in Excel (5 Effective Ways)

How to Calculate Variable Cost Per Unit in Excel (with Quick Steps)

Nov 11, 2025

In our daily calculation and management work, we need to evaluate the Variable Cost of various components. If you are curious to know how you can ...

How to Calculate Variable Cost Per Unit in Excel (with Quick Steps)

How to Calculate Area in Excel Sheet: 2 Methods

Jul 5, 2024

Method 1 - Calculate the Area under a Scatter Plot in an Excel Sheet 1.1 Using Trapezoidal Rule Steps: Insert a scatter plot for the dataset. ...

How to Calculate Area in Excel Sheet: 2 Methods

How to Calculate Sales Commission Formula in Excel (3 Easy Ways)

Apr 30, 2024

Method 1 - Calculate the Sales Commission with a Simple Formula in Excel We will use a dataset that contains information about the sales amount of ...

How to Calculate Sales Commission Formula in Excel (3 Easy Ways)

How to Calculate Average Sales per Month in Excel (2 Easy Methods)

Jul 19, 2024

Method 1 - Calculate the Average Sales per Month with the AVERAGE Function The sample dataset contains the monthly sales for the last 3 years. We'll ...

How to Calculate Average Sales per Month in Excel (2 Easy Methods)

How to Create a Bell Curve with Mean and Standard Deviation in Excel

Jul 16, 2024

What Is a Bell Curve? The bell curve, also known as the normal distribution curve, illustrates the typical spread of a variable. It's a common ...

How to Create a Bell Curve with Mean and Standard Deviation in Excel

How to Calculate Projected Cost in Excel (4 Effective Ways)

Jul 6, 2024

Method 1 - Using Conventional Formula We mentioned the cost of 6 months of 2021 in the range of cells D5:D10. We considered a projection of a 20% ...