TechPlip
    • Alternatives
    • Android
    • Apple
      • Apple TV
      • iPhone
    • Best
    • Smart TV
    • Smart Watch
      • Apple Watch
      • Fitbit
    • Social
      • Twitter
      • Whatsapp
    • Windows
    TechPlip
    Home»How to»How to Subtract in Excel [4 Different Ways]
    How to

    How to Subtract in Excel [4 Different Ways]

    By AdminApril 27, 2021Updated:April 27, 2021No Comments3 Mins Read
    Facebook Twitter Pinterest LinkedIn Tumblr Email
    How to Subtract in Excel
    How to Subtract in Excel
    Share
    Facebook Twitter LinkedIn Pinterest Email

    Microsoft Excel is a spreadsheet created by Microsoft Corporation for different platforms. It is used to store data in an organized manner and also used as a tool for calculations and creating a chart like a pie chart, bar chart, etc. Excel sheets are used for multiple purposes in the business firms to forecast future performance, calculate tax, completing basic payroll, producing charts and calculating revenues, etc. Apart from that, it also helps you to do calculations like Addition, subtraction, multiplication, division, etc. In this article, let’s see some of the ways to subtract two values in an excel sheet.

    Ways to Subtract in Excel

    There are four ways to subtract in Excel, and each differs from the other in different ways.

    • Subtract inside cell
    • Directly via formula bar
    • Using formula
    • Paste special method

    Subtract inside cell

    [1] Click on any cell in your excel sheet.

    [2] Type equal (=) sign in the cell, followed by the number you need to subtract. (Example: =50-10-10)

    Subract in excel

    [3] Press the enter key on your keyboard.

    [4] Now the result will be displayed in the cell. (Result: 50-10-10 = 30)

    result

    Related Guide: How to Download Embedded Videos

    Subtract in Excel Directly via Formula Bar

    [1] Click on any cell in the excel sheet.

    [2] Now go to the formula bar.

    [3] Type equal (=) sign followed by the number you need to subtract. (Example: =50-10)

    How to Subtract in Excel

    [4] Press the enter key on your keyboard.

    [5] Now, the result will be displayed in the selected cell. (Result: 40)

    Result

    How to Subtract in Excel using Formula

    [1] Click on any cell (e.g. A1) and type a number.

    [2] Click on another cell (e.g. A2) and type another number.

    [3] Now go to the cell where you want to display the result.

    [4] On the formula bar,

    • Type (=)
    • Select the first cell that you want.
    • Enter the subtract symbol (-)
    • Select the second cell that you want.
    • Press the enter key, and the result will display on the selected cell.

    Related Guide: How to Remove Section Break in Word

    Paste Special Method

    [1] Click on any cell and type the number you need to subtract (e.g. 10).

    [2] Copy the cell by right-clicking the mouse or by pressing Ctrl + C.

    Copy

    [2] Now type any random number on more than two cells.

    [3] Select all the cells that you need to subtract.

    [4] Right-click on the cell and select Paste special.

    [5] In the Paste special tab, select the Subtract operation and click on OK.

    {Paste special

    [6] Now the numbers in the selected cells will be subtracted by 10 (the number copied to subtract) in each cell.

    How to Subtract in Excel

    These are some of the ways to subtract in excel. You can use the same method for addition, multiplication, and division by just entering the respective signs. Let us know in the comment section if we have missed any technique.

    Guide Microsoft Excel Productivity
    Share. Facebook Twitter Pinterest LinkedIn Tumblr Email
    Previous ArticleHow to Connect Xbox One Controller to PC [3 Easy Ways]
    Next Article How to Cancel Amazon Fresh Subscription [Step By Step]
    Admin

    I am the Admin of TechPlip.com and I have written a variety of tech-related subjects - from news to reviews. I am a tech enthusiast focused in providing the best tech contents.

    Related Posts

    How to Reset Samsung Smart TV to Factory Settings

    March 28, 2023 How to

    How to Turn on Fossil Sport Smartwatch [2 Methods]

    March 18, 2023 Fossil

    How to Reset Samsung Galaxy Watch [Step by Step]

    March 13, 2023 How to

    Leave A Reply Cancel Reply

    How to Reset Samsung Smart TV to Factory Settings

    March 28, 2023

    How to Install and Watch Hulu on Apple TV

    March 22, 2023

    How to Turn on Fossil Sport Smartwatch [2 Methods]

    March 18, 2023

    How to Reset Samsung Galaxy Watch [Step by Step]

    March 13, 2023

    How to Add Channels to Roku Using 3 Methods

    March 7, 2023

    How to Enable Dark Mode on Google Photos

    March 6, 2023

    How to Cancel Sling TV Subscription [Step By Step]

    March 1, 2023

    How to Delete Search History On Instagram [2023]

    February 27, 2023
    • Home
    • Privacy Policy
    • Affiliates Disclosure
    • Contact Us
    © 2023 TechPlip.

    Type above and press Enter to search. Press Esc to cancel.