In a third cell, use the following formula: =original amount * (1 - percentage). Type a comma (,) to separate the arguments.Ĭlick on the cell that contains the value you want to subtracT.Įnter the percentage you want to subtract in another cell, preceded by the minus sign (-). Type 'IMSUB' to start the SUBTRACT function.Ĭlick on the cell that contains the value you want to subtract from. To use the SUBTRACT function, you need to specify the two values you want to subtract. WPS Office Spreadsheet offers a variety of built-in functions, including the SUBTRACT function. Type the equal sign (=) to start the formula.Ĭlick on the cell that contains the value you want to subtract and make sure to add ‘$’ sign to add absolute reference. Type the equal sign (=) to start the subtraction formula in excel.Ĭlick on the cell that contains the value you want to subtract from minuend.Ĭlick on the cell that contains the value you want to subtract subtrahend. Select the cell where you want to display the result of the subtraction. Here are the steps for each method: Subtraction with Basic Operators: WPS Office Spreadsheet offers multiple ways to subtract values in two cells. The dollar sign before the 'A' and the '2' in '$A$2' fix the row and column reference for cell A2, so that when you copy the excel subtraction formula to other cells, it always subtracts the value in cell A2. To do this, you need to use the dollar sign ($) to fix one part of the cell reference while allowing the other part to change.įor example, if you want to subtract the value in cell A2 from the value in cell B2 and display the result in cell C2, you would type '=B2-$A$2' into cell C2.

However, if you want to subtract the value in one cell from the value in another cell, you need to use a mixed cell reference. For example, to subtract 5 from 10, you would type ' =(10-5)' into a cell. In a WPS Office Spreadsheet, you can subtract two numbers by simply typing a minus sign (-) between them.

It provides a variety of features similar to those in Excel, including the Subtract feature we will discuss in this guide. WPS Office offers a free Excel spreadsheet editor, making it an excellent alternative for those who prefer a free and user-friendly option. In this guide, we will focus on the Subtract feature in Excel, which allows you to perform basic subtraction operations quickly and efficiently. With a basic understanding of the program's operations, anyone can use it. Excel is a widely used software that doesn't require expertise in any particular field.

Excel how to subtract formula