Excel Formulas Archives - Page 47 of 112

How to Calculate Bonus in Excel (5 Handy Methods)

Apr 16, 2024

Here we’ve got a dataset of the Daily Sales List of Sales Reps and their Daily Sales. Also, have a Sales Hurdle of $15,000 and a Bonus Percentage of ...

How to Calculate Bonus in Excel (5 Handy Methods)

How to Add Margin to Cost Using an Excel Formula (4 Examples)

Jul 10, 2024

Different Types of Costs 1. Fixed Cost Fixed costs remain unchanged regardless of the production level within a specific time period. ...

How to Add Margin to Cost Using an Excel Formula (4 Examples)

How to Calculate Distance Between Two GPS Coordinates in Excel

Apr 16, 2024

To showcase the methods, the sample will use a simple dataset that lists the Latitude and Longitude values of Prague, Czech Republic, and Salzburg, ...

How to Calculate Distance Between Two GPS Coordinates in Excel

How to Calculate Sliding Scale Commissions using Excel Formulas (5 Methods)

Jul 10, 2024

What Is Sliding Scale Commission? Sales employees play a crucial role in any company and motivating them to achieve higher sales targets is ...

How to Calculate Sliding Scale Commissions using Excel Formulas (5 Methods)

How to Insert Static Date in Excel (4 Simple Methods)

Jul 4, 2024

The following dataset has some Orders. We’ll insert a static Date for each order. Method 1 - Apply a Keyboard Shortcut in Excel to Insert ...

How to Insert Static Date in Excel (4 Simple Methods)

How to Calculate the Contribution Margin in Excel – 2 Examples

Aug 13, 2024

The Contribution Margin The Contribution Margin shows the difference between the total sales and the total direct variable costs. The ...

How to Calculate the Contribution Margin in Excel – 2 Examples

How to Calculate Price Per Square Meter in Excel: 3 Handy Methods

May 24, 2024

Method 1 - Dividing Total Cost by Total Area to Calculate Price Per Square Meter The following table has Total Area in m2, Total Price, and Price/m2 ...

How to Calculate Price Per Square Meter in Excel: 3 Handy Methods

How to Convert Lbs to Kg in Excel (3 Easy Methods)

Jul 15, 2024

We have a dataset of some Patient Names and their Weight in pounds. Method 1 - Use the CONVERT Function to Convert Lbs to Kg in Excel ...

How to Convert Lbs to Kg in Excel (3 Easy Methods)

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 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 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 ...