inkolz.blogg.se

Microsoft allows us to use the SUM function to subtract multiple numbers, including the negative values. Method 4: Subtract multiple numbers (including negative numbers) Note: In our case, result 120 display on cell B7.

Now, the result will be displayed in the selected cell. Step 4: Once the SUM function is completed, Press the Enter key from the keyboard. Step 3: Type the equal (=) sign, add up all subtrahends (in our case B2 to B6) using the SUM function, and then subtract the sum from the first cell (In our case B1) as shown in the below screenshot. Step 2: Place the cursor in the cell where you want the result to appear. Step 1: Double click on the Microsoft Excel icon to open a Microsoft Excel document. To subtract numbers using this method, you can use the below given syntax. This method is used to make the formula more compact, easy to understand, and easy to use. Method 3: Subtract multiple numbers using the SUM function Now, the subtraction result will appear in the selected cell (cell B5). Once you complete the formula, press Enter key from the keyboard. Note: you can also use cell names such as =B1-B2-B3-B4 to perform the subtraction.ģ. After the equal sign, type the first number, type the second number followed by the minus (-), type the third number followed by the minus (-) sign, and so on. Step 3: In the selected cell (cell B5), perform the following operations -Ģ.

Step 2: Place the cursor in the cell where you want the result to appear (we use cell B5). Note: In our case, we want to subtract 125, 18, and 5 from 989. Step 1: Open a Microsoft Excel document and enter numbers to perform subtraction. Steps to perform two or more numbers subtraction