Skip to content
excelkeys

Excelkeys

  • Home
  • Privacy Policy
  • About Us
  • Contact Us
  • Most Used Functions
  • Excel
  • Toggle search form

How to Use SUBTRACT Function/Method in Excel?

Posted on July 6, 2022January 29, 2023 By Excelkeys No Comments on How to Use SUBTRACT Function/Method in Excel?

There’s no SUBTRACT function in Excel. However, there are many methods to subtract numbers in Excel. Are you willing to enhance your Excel knowledge? Then stay with us.

1. In this way, you can subtract values. You can see below we show the example. = A1-A2-A3

SUBTRACT function in Excel


2. As you can guess, this formula can get long. Just use the SUM function to compress your formula. For example, the formula subtracts the values in the range A2:A6 from the value in cell A1.

SUBTRACT function in Excel


3. Now in the next method, you can subtract a value from another cell value. Subtract B1 from the value in cell A1 See the example below.

SUBTRACT function in Excel

Drag C1 corner down to the cell

SUBTRACT function in Excel

4. Subtract the value in cell A8 from the value in cell A1. Set the reference to cell A8 by putting a symbol($) in front of the column letter and row number ($A$8).

SUBTRACT function in Excel

The lower right corner of cell B1 and drag it down to cell B6.

SUBTRACT function in Excel
Most Used Functions

Post navigation

Previous Post: Most Used Functions in Excel
Next Post: How to Use Multiply Funtion in Excel?

Related Posts

How To Convert, Increase, Decrease, or Change Numbers to Percentages in Excel? Most Used Functions
How to Use Divide Function in Excel? Most Used Functions
How to Use Multiply Funtion in Excel? Most Used Functions
Most Used Functions in Excel Most Used Functions
How to Convert Number into Square/Qube Root in Excel? Most Used Functions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Recent Posts

  • How to Repeat Last Action in Excel?
  • How to Remove Blank Entries/Cells From a Drop Down List in Excel?
  • How to add a comma after the first word in each cell?
  • How to Add a Blank Option to a Drop-Down List in Excel?
  • How To Convert, Increase, Decrease, or Change Numbers to Percentages in Excel?
  • How to Convert Number into Square/Qube Root in Excel?
  • How to Use Divide Function in Excel?
  • How to Use Multiply Funtion in Excel?
  • How to Use SUBTRACT Function/Method in Excel?
  • Most Used Functions in Excel

Category

  • Excel
  • Most Used Functions

Latest Posts

  • What is Excel?
  • How to Use Vlookup Function in Excel? A Complete Guide
  • Main Features of Excel
  • Contact Us
  • All Shortcut Keys of Excel
  • Duplicate Formula of Excel: How to Find and Remove Duplicate Entries
  • Types of Errors in Excel: #N/A Error, #DIV/0! Error, #VALUE! Error, #REF! Error, #NAME ERROR, #NUM ERROR
  • ASCII Codes in Excel
  • Most Used Functions in Excel
  • How to Use SUBTRACT Function/Method in Excel?

Copyright © 2023 Excelkeys.

Powered by PressBook Grid Dark theme