How do you subtract 3 cells in Excel?

Excel 101Excel FunctionsExcel FormulaContact UsType your search query and hit enter: All Rights ReservedView Non-AMP VersionType your search query and hit enter: HomepageExcel

How do you subtract 3 cells in Excel?
  • Excel 101
  • Excel Functions
  • Excel Formula
  • Contact UsType your search query and hit enter:   All Rights ReservedView Non-AMP VersionType your search query and hit enter:
  • Homepage
  • Excel FormulaCategories: Excel Formula

How to Subtract Multiple Cells from One Cell in ExcelSUMIFS Limitations and SolutionsTable of contents :

  • Subtract Multiple Cells Using Formula
  • Subtract Multiple Cells Using No Formula
  • Which One is the Best Solution?

For example, there are data such as the image below.

How is the fastest way to subtract numbers in column A with a number in cell B1?

Subtract Multiple Cells Using Formula

You need an absolute cell reference for subtracting numbers with a number. Make the cell reference of the deduction number absolute, to prevent the cell address changing when the formula is copied.

Here are the steps to make the formula:

  1. Place the cursor in cell C1
  2. Type the equal sign =
  3. Point the cursor to cell A1
  4. Type the minus sign -
  5. Point the cursor to cell B1, make it an absolute reference by pressing the F4 key once
  6. Press the Enter key

For other numbers, make a copy in cell B1 (CTRL+C), then paste (CTRL+V) in range C2:C10. The result is like the animation below.

All numbers in column C are numbers in column A subtracted by a number in cell B1.

Please read the article below for a more detailed explanation of absolute reference

  • How to Make an Absolute Reference in Excel

Subtract Multiple Cells Using No Formula

The solution to subtract several numbers with a number without using a formula is to use special paste.

Here are the steps:

  1. Place the cursor in the subtraction number position (cell B1)
  2. Do a copy (CTRL+C)
  3. Make a range A1:A10, containing the numbers that will be subtracted
  4. Do a paste special (CTRL+ALT+V)
  5. Select Subtract in the Operation section
  6. Click the OK button

The result is as shown below. All numbers in column A automatically change.

Which One is the Best Solution?

Which is the best solution? It depends on your needs. If you want to keep the original number, using a formula solution is better for you. Otherwise, the paste special solution is better for you.

Related ArticleAnother articles related to this article

  • How to Create a Formula in Excel
  • How to Subtract in Excel
  • Paste Special ExcelNextHow does Excel Store Dates and Times? »Previous « SUMPRODUCT IF - Multiple Criteria SUMPRODUCTShare
  • Tags: How to SubtractHow to Subtract Multiple Cells From One Cell in ExcelHow to Subtract Multiple Cells in ExcelHow to Subtract Numbers in ExcelHow to Subtract One Cell From Another in ExcelHow to Subtract One Column From Another in ExcelPaste SpecialSubtraction Formula

Related Post

  • Get the Original Price from Percentage Increase/Decrease

Get the Original Price from Percentage Increase What was the original price of the smartphone

  • How to Add/Subtract Percentage in Excel

Add Percentage in Excel What is the price of each cell phone after the price

  • How to Extract Day, Month and Year from Date in Excel

Excel provides three different functions to extract a day, month, and year from date. The

Recent Posts

  • Excel Formula

Get the Original Price from Percentage Increase/Decrease

Get the Original Price from Percentage Increase What was the original price of the smartphone before the price increase? Current3 years ago

  • Excel Formula

How to Add/Subtract Percentage in Excel

Add Percentage in Excel What is the price of each cell phone after the price increase? You can use the3 years ago

  • Excel Formula

How to Extract Day, Month and Year from Date in Excel

Excel provides three different functions to extract a day, month, and year from date. The following is an explanation of3 years ago

  • Excel Formula

How to Add Seconds, Minutes and Hours to a Time in Excel

Excel stores date value in integer number and time value in decimal number. 1 day = 24 hours 1 hour3 years ago

  • Excel Formula

How to Add Days, Weeks, Months and Years to a Date in Excel

How to add DAYS to a date in Excel Excel stores date value in integer number, to find out n3 years ago

  • Excel Formula

How to Calculate Time Difference in Excel

How many hours between two times? To get hours between two times, use the subtraction formula. A result is a3 years ago

  • Excel 101
  • Excel Functions
  • Excel Formula
  • Contact UsAll Rights ReservedView Non-AMP Version

Video liên quan