Excel Formulas Archives - Page 45 of 112

How to Create a Monthly Salary Sheet Format in Excel

Apr 26, 2024

Here's the dataset we'll build on. We have some employees and their basic salary. We will calculate their net salary and deductions. Step ...

How to Create a Monthly Salary Sheet Format in Excel

How to Calculate Discount in Excel (2 Easy Methods)

May 9, 2024

Method 1 - Creating an Excel Formula to Calculate a Discount Price Suppose we have a dataset of a Mobile selling shop with their product ...

How to Calculate Discount in Excel (2 Easy Methods)

How to Create Salary Slip Format with Formula in Excel Sheet

Apr 26, 2024

Let’s assume we have a large worksheet that contains the information about several Employee salary statements. The data for the Employee name, the ...

How to Create Salary Slip Format with Formula in Excel Sheet

Calculate Hours Between Two Times After Midnight – 3 Methods

Aug 3, 2024

In the dataset below, the start time is on the current day and the end time is on the next day. Method 1 - Use a Simple Excel Formula to ...

Calculate Hours Between Two Times After Midnight – 3 Methods

How to Calculate Area of Irregular Shape in Excel (3 Easy Methods)

Jul 4, 2024

To illustrate the calculations, we will use the sample dataset below. Method 1 - Determine Area of Irregular Shape by Simple Calculation ...

How to Calculate Area of Irregular Shape in Excel (3 Easy Methods)

How to Calculate 10 Percent Discount in Excel (With Easy Steps)

May 15, 2024

Step 1 - Create the Dataset List down some items in column B. We put the price for each item in column C. The 10% discount for ...

How to Calculate 10 Percent Discount in Excel (With Easy Steps)

How to Calculate Sales Growth over 3 Years in Excel (2 Methods)

Aug 2, 2024

Sales growth over various periods is one of the key performance indicators for most companies. In this article, we will demonstrate how to calculate ...

How to Calculate Sales Growth over 3 Years in Excel (2 Methods)

How to Use Nested IF Function in Excel: 7 Methods

Jun 13, 2024

Method 1 - Use Nested IF Function to Find Multiple Results Based on Criteria If a student gets 70 or higher, then he will pass. If he gets ...

How to Use Nested IF Function in Excel: 7 Methods

How to Calculate Log Base 2 in Excel (2 Methods)

May 8, 2024

Method 1 - Use Excel LOG Function The LOG function computes the logarithm of a number to a particular base. In order to use the LOG ...

How to Calculate Log Base 2 in Excel (2 Methods)

How to Remove Asterisk in Excel (5 Simple Methods)

Jul 4, 2024

Suppose we have a dataset of a fruit shop containing columns for Product, Product Code, & Total Sales. We will remove the asterisk sign from the ...

How to Remove Asterisk in Excel (5 Simple Methods)

How to Calculate Bonus Percentage in Excel: 4 Methods

May 30, 2024

Method 1 - Applying Direct Arithmetic Formula to Find Ratio Apply an arithmetic formula to calculate the Bonus Percentage. Find out the Ratio in ...

How to Calculate Bonus Percentage in Excel: 4 Methods

How to Calculate Production Cost in Excel (3 Effective Ways)

May 30, 2024

The production cost is the total cost of manufacturing items or providing services, including all intended and unintended expenses. It can be ...

How to Calculate Production Cost in Excel (3 Effective Ways)

Bonus Calculation as per Bonus Act in Excel (3 Suitable Examples)

Jul 14, 2024

In this article we will demonstrate several methods to calculate employee Bonuses in accordance with the USA's Bonus Act in Excel. Overview of ...

Bonus Calculation as per Bonus Act in Excel (3 Suitable Examples)

How to Calculate Cut and Fill Volume in Excel (3 Steps)

Jul 28, 2024

Step 1 - Formatting Data in Excel to Calculate Cut and Fill Volume To make the data more understandable, we’ll format it appropriately. ...

How to Calculate Cut and Fill Volume in Excel (3 Steps)

How to Filter Last 30 Days of Date in Excel (5 Easy Ways)

Jun 11, 2024

Suppose we have the following dataset containing dates along with other entries, and we want to filter the dataset to only show entries from the last ...