Excel Formulas Archives - Page 83 of 149

How to Add and Subtract Multiple Cells in Excel: 3 Methods

May 21, 2024

Method 1 - Add Multiple Cells and Subtract from One Cell Steps: Cell E11, enter the following formula, and then, press ENTER. ...

How to Add and Subtract Multiple Cells in Excel: 3 Methods

How to Subtract Two Columns in Excel (4 Easy Ways)

Jun 16, 2024

To subtract two columns in Excel: Select a blank cell and insert the formula with the references for the columns such as: =A1-B1, then use the ...

How to Subtract Two Columns in Excel (4 Easy Ways)

How to Split Names in Excel into Two Columns (4 Quick Ways)

Apr 25, 2024

In column B5:B10, we have full names. Let's split these names into the First Names and Last Names columns. Method 1 - Using the Convert ...

How to Split Names in Excel into Two Columns (4 Quick Ways)

How to Subtract in Excel Based On Criteria (3 Examples)

Jul 26, 2024

Example 1 - Subtraction of Excel Data Based on an Empty Cell Suppose we have a dataset with empty cells. We want to subtract cell values based on ...

How to Subtract in Excel Based On Criteria (3 Examples)

How to Calculate Absolute Difference between Two Numbers in Excel

Jul 29, 2024

We have Permissible Speed Limits (mph) for different states along with the tendency of drivers’ Average Speeds (mph). From these two numbers, we want ...

How to Calculate Absolute Difference between Two Numbers in Excel

How to Sum to End of a Column in Excel (8 Methods)

Jun 20, 2024

We will determine the sum of a column up to the bottom in Excel. We have taken a dataset that shows the store's sales for the month of ...

How to Sum to End of a Column in Excel (8 Methods)

How to Replace Text with Blank Cell in Excel (5 Simple Methods)

Nov 11, 2025

This tutorial will demonstrate 5 simple methods to replace text with a blank cell in Excel. When working with a dataset, we may need to eliminate ...

How to Replace Text with Blank Cell in Excel (5 Simple Methods)

How to Separate Date from Text in Excel (4 Methods)

Apr 23, 2024

Method 1 - Combining MID, SEARCH & DATEVALUE Functions to Separate Date from Text in Excel Let’s consider the following dataset with ...

How to Separate Date from Text in Excel (4 Methods)

How to Subtract from a Total in Excel (3 Quick Methods)

Jun 17, 2024

Method 1 - Subtract from a Total in Excel Using Relative Cell Reference Insert the following formula in cell E5. =C5-D5 C5 has ...

How to Subtract from a Total in Excel (3 Quick Methods)

Calculate Time Difference Between Two Dates in Minutes in Excel – 6 Methods

Aug 9, 2024

The dataset showcases Soldiers' names ans their training time. Method 1 - Using the Excel Arithmetic Operator to Calculate the Time Difference ...

Calculate Time Difference Between Two Dates in Minutes in Excel – 6 Methods

How to Use an Excel Formula to Replace Text with Number (5 Examples)

Jul 7, 2024

Method 1 - Applying an Excel Formula with the SUBSTITUTE Function to Replace Text with Number Steps: Select cell C4. Enter the ...

How to Use an Excel Formula to Replace Text with Number (5 Examples)

Excel Formula to Split String by Comma (5 Examples)

May 13, 2024

In the below dataset, ID no., LastName, and Dept. are kept as a single string separated by commas. Our goal is to split the strings into 3 columns. ...