The screenshot below shows a few more formulas to subtract numbers in Excel: To indicate which part of the formula should be calculated first, use parentheses. Like in math, you can perform more than one arithmetic operation within a single formula.įor example, to subtract a few numbers from 100, type all those numbers separated by a minus sign: Type the first number followed by the minus sign followed by the second number.Ĭomplete the formula by pressing the Enter key. In a cell where you want the result to appear, type the equality sign ( =). To enter the formula in your worksheet, do the following steps: The basic Excel subtraction formula is as simple as this:įor example, to subtract 10 from 100, write the below equation and get 90 as the result: Here To perform a simple subtraction operation, you use the minus sign (-). Let's understand how to use the function using an example.
Let's learn each of the above mentioned methods taking one by one to understand how subtraction works in excel.Īll of these might be confusing to understand. Now, let's take a look at how you can do all this. You can even subtract matrices, text strings and lists. Subtraction formula in Excel (minus formula) What kind of things can you subtract in your worksheets? Just any things which excel understands as numbers: such as numbers, percentages, days, months, hours, minutes and seconds. Subtraction is one of the four basic arithmetic operations, and every primary school pupil knows that to subtract one number from another you use the minus sign. In this article, we will learn how to apply Subtraction in Excel.
0 kommentar(er)
