![]() ![]() 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 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |