HomeApplicationOffice information

How to use subtraction in Excel

Excel functions or Excel formulas are all basic tools for users to process data in data tables. Subtraction in Excel has no calculation function to implement, but we will use the '-' operator. Subtraction is used for many different cases, except for many cells in the data table, except for the percentage in Excel to apply to each different calculation. The following article will guide you how to use subtraction in Excel as well as some examples of subtraction.

  1. The easiest way to calculate the percentage (%)
  2. How to use the kernel function (PRODUCT function) in Excel
  3. 3 ways to calculate totals in Excel
  4. How to automatically calculate and copy formulas in Excel

Instructions for performing subtraction in Excel

1. Subtract many cells in Excel

To perform calculations except for many cells in Excel, we will use the '-' operator or use the SUM function in Excel.

Example 1: Use a minus sign

With the use of the minus sign, we only need to enter the = sign and then enter the subtraction for the numbers to be calculated in the data table and press Enter to get the result.

How to use subtraction in Excel Picture 1

Example 2: Use the SUM function

The SUM function for calculating subtraction in Excel will have 2 ways to do it. We will add - to convert arguments to negative values , thus subtracting. Follow the way through the example table below.

How to use subtraction in Excel Picture 2

Or we use the formula = D3-SUM (D4: D5) and also give the same result. The simple interpretation of this calculation is D3- (D4 + D5).

How to use subtraction in Excel Picture 3

2. Subtract percentages from Excel

The subtraction of% in Excel is still done as usual when calculating subtraction.

How to use subtraction in Excel Picture 4

Or if you want to perform subtraction from a number to calculate the percentage value, press the formula = Number * (1-x%). You follow how to follow the example below.

How to use subtraction in Excel Picture 5

3. Subtract dates from Excel

The simple way to do it is to use the '-' sign in the calculation except the date. Or we use the DATE function in Excel to calculate the date value.

How to use subtraction in Excel Picture 6

Above is how to use subtractions in Excel and some examples using subtraction. Subtraction is very simple, just apply the '-' operator.

I wish you all success!

5 ★ | 1 Vote
excel excel

You should read it

May be interested

  • Shortcut guide, abbreviated in ExcelShortcut guide, abbreviated in Excel
    the autocorrect feature in excel is a shorthand feature, which shuts down frequently written words that appear in content, without rewriting many times.
  • Microsoft Excel test P5Microsoft Excel test P5
    in the article below, network administrator will send you more useful information about excel software through the following quiz. let's see how much you know about excel.
  • How to fix the insertion block in ExcelHow to fix the insertion block in Excel
    inserting shape shapes into excel is very simple. so how to fix the inserted shapes into excel?
  • Test Microsoft Excel P16Test Microsoft Excel P16
    when using an application regularly, you will often get used to it and handle it faster. are you confident enough about your ability to use excel? try a little test to measure your excel proficiency!
  • Summary of expensive shortcuts in Microsoft ExcelSummary of expensive shortcuts in Microsoft Excel
    in the work, especially when you have to perform many calculations, the formula in microsoft excel documents, the use of the mouse is strictly tortuous. not wrong, because when you master the formulas, shortcut keys on excel, using the keyboard will be fast and convenient a lot.
  • How to disable Hyperlink in ExcelHow to disable Hyperlink in Excel
    when you want to copy a certain line of text in excel, you have hyperlink. if the link is contained, when we check the text, we will access the inserted web page. so how to do it?
  • Complete tutorial of Excel 2016 (Part 5): Basics of cells and rangesComplete tutorial of Excel 2016 (Part 5): Basics of cells and ranges
    whenever you work with excel, you will need to enter information - or content - into the cells . cells are the basic building blocks of a spreadsheet. you will need to learn the basics of cells and cell contents to calculate, analyze, and organize data in excel.
  • How to draw charts in ExcelHow to draw charts in Excel
    drawing diagrams on excel are basic and often done, when displaying data based on tables or comparing figures together.
  • How to draw a map chart on ExcelHow to draw a map chart on Excel
    in excel 2019, there is a map diagram, showing the names of countries in the world.
  • Simple way to convert Excel files to PDFSimple way to convert Excel files to PDF
    converting excel files to pdf will help create more professional documents, preventing the spreadsheet from being modified during the exchange process. so how to convert excel to pdf?

Office information