Excel Formulas Archives - Page 71 of 112

Count Cells by Color with Conditional Formatting in Excel (3 Methods)

May 3, 2024

The sample dataset contains the Salesman, Product, and Net Sales of a company. The Conditional Formatting feature in Excel is used ...

Count Cells by Color with Conditional Formatting in Excel (3 Methods)

Excel Formula to Count Cells with Specific Color (4 Ways)

Jul 4, 2024

We have attached a sample workbook containing sales information, including Date, Product, Country, Quantity, and Sales. How to Count Cells ...

Excel Formula to Count Cells with Specific Color (4 Ways)

How to Count Colored Cells In Excel Without Using VBA – 3 Methods

Aug 11, 2024

The Excel file contains information about students from different countries in a university. The Country is color-coded. The image below shows the ...

How to Count Colored Cells In Excel Without Using VBA – 3 Methods

How to Calculate Time Difference Between AM and PM in Excel (6 Ways)

Jul 28, 2024

We'll calculate the time difference in various units, including hours, minutes, seconds, and also for negative values. Here's the sample dataset ...

How to Calculate Time Difference Between AM and PM in Excel (6 Ways)

How to Calculate the Percentage of Time in Excel – 4 Examples

Aug 4, 2024

Basic Formula to calculate the Percentage =(Part/Total)*100 Excel automatically multiplies the result of the ‘=Part/Total’ portion with 100 ...

How to Calculate the Percentage of Time in Excel – 4 Examples

How to Calculate Average of Multiple Ranges in Excel (3 Methods)

Jul 3, 2024

Our sample dataset contains player names and their scores in different games. We'll use this data to practice calculating the average of specific ...

How to Calculate Average of Multiple Ranges in Excel (3 Methods)

How to Solve Text Won’t Convert to Date in Excel (4 Problems & Solutions)

Jul 21, 2024

Dataset Overview Let’s consider a dataset containing employee information, including their joining dates. Unfortunately, these dates are not in the ...

How to Solve Text Won’t Convert to Date in Excel (4 Problems & Solutions)

How to Count Number of Cells with Dates in Excel (7 Ways)

Apr 25, 2024

Let's use a sample dataset containing Name, Gender, and Date of Birth to showcase how you can count how many cells contain dates in Excel. ...

How to Count Number of Cells with Dates in Excel (7 Ways)

How to Calculate Accrued Interest on a Bond in Excel (5 Methods)

Jul 3, 2024

We will show how to calculate this accrued interest on a bond using different formulas in Excel. We will calculate the accrued interest based of the ...

How to Calculate Accrued Interest on a Bond in Excel (5 Methods)

How to Calculate Production per Hour in Excel (4 Methods)

Jul 28, 2024

Method 1 - Using Target Efficiency and Working Period Start with a productive facility that has 6 working units. Each unit has its own machine ...

How to Calculate Production per Hour in Excel (4 Methods)

How to Bold Text in a Concatenate Formula using VBA in Excel – 2 Methods

Aug 3, 2024

This is the sample dataset. Method 1 - Bold Text in the Output of the Concatenate Formula. Press ALT+F11 to open VBA. In the VBA window, ...

How to Bold Text in a Concatenate Formula using VBA in Excel – 2 Methods

How to Add a Percentage to a Price with an Excel Formula – 2 Methods

Aug 9, 2024

Importance of Cell Number Formatting in Percentage Calculation To enter a percentage you have to use Number format. Steps: Enter a decimal ...

How to Add a Percentage to a Price with an Excel Formula – 2 Methods

Concatenate Multiple Cells but Ignore Blanks in Excel (5 Ways)

Jun 3, 2024

Method 1 - Combine CONCATENATE, IF, and ISBLANK Functions to Concatenate Multiple Cells Consider the following dataset. In column B, we have ...

Concatenate Multiple Cells but Ignore Blanks in Excel (5 Ways)

Carriage Return in Excel Formula to Concatenate (6 Examples)

Jul 4, 2024

Method 1 - Using Ampersand Operator and CHAR Functions Insert Carriage Return in Excel Formula to Concatenate Step 1: Insert the following formula ...

Carriage Return in Excel Formula to Concatenate (6 Examples)

How to Calculate Average Turnaround Time in Excel (4 Methods)

Jul 4, 2024

Method 1 - Compute the Average Turnaround Time in Excel Look at the following picture. We have the Start Time and the End Time of some ...