The Excel Minus Formula is one of the four basic arithmetic operations.Similarly, we can use the function to subtract values in excel. Step 4: We can manually enter the formula in all the cells or use the AutoFill option. We can see that the function has returned the result as $312,434,469 in cell D2. The steps used to find values with Excel Minus formula are as follows: We need to calculate turn over profit from the values with Minus Formula in Excel. The table shows a few companies’ sales and purchases data in columns A, B and C respectively. Likewise, we can obtain values with Minus formula. The function has returned the result as $36,500 in cell B6 by subtracting all values from Basic Pay. Step 2: Enter the complete formula, =B2-B3-B4-B5 Step 1: Select an empty cell to display the output. The steps used to obtain results by inserting minus formula are as follows: Column A contains the Detail of the Salary of Employees.In the table, the data is reflected as below: We need to calculate the total annual salary from the values using Minus Formula in Excel. The below table shows the employee’s annual salary. Similarly, we can use Excel minus formula to obtain results. Step 4: Drag the AutoFill arrow to D5 to obtain subtracted values in other cells. The image below shows the results in cell D2, as the minus of the numbers is $50. Step 1: Select an empty column to display the output. The steps used to find the subtracted values using Minus Formula in Excel are as follows: First, we need to calculate profit from the values with Minus Formula in Excel. The below table shows the selling price and cost price of fruits. Let us look at the following examples to understand the formula. Likewise, we can find the subtracted value using minus formula. We can see that the function has returned the value of 50. Step 2: Enter the Minus Formula in Excel. We have selected merged cells A3 and A4 in this case. The steps to obtain the result with Minus Formula in Excel are as follows:

We need to use the following steps to find the subtracted value by inserting Minus Formula. The below table shows two values, one in cell A2 and the other in cell B2. Type = for entering the Minus Formula in Excel.We can enter the function in the worksheet directly with the below steps How To Use Minus Formula In Excel? (With Steps) The Minus Formula method we have covered will work with all the versions of Excel.It is the easiest method to subtract time and get its differences.The basic rules of Mathematics such as the BODMAS rule is followed in this formula.The Excel Minus Formula is applied on percentage formatting in case of decimal results.The numbers or cell references can be entered directly when using the Excel Minus formula.

Excel formula subtract