In our example, that would look like: =A5-A6 Step 2: Click on a blank cell in your spreadsheet and type in the following formula, omitting the spaces and brackets and filling in your numbers' cell references where appropriate: For example, if one of your numbers is in a cell that is located in column A and row 6, the cell reference for that number would be A6.) (A cell reference is a way to denote the location of a given cell in a spreadsheet and the combination of a cell's column number and row number. Step 1: Choose the numbers you want to subtract and make note of their respective cell references. If you have numbers located in different cells in your spreadsheet that you want to subtract, you can do so by using cell references and a formula. Google’s ChatGPT rival just launched in search.

While the resulting value is correct, it’s not in the right format that you want in the cell.Īnd this has a really easy fix – you just need to change the cell format.The most common Microsoft Teams problems, and how to fix them Sometimes you’ll notice that after you have subtracted a percentage value from a number, the resulting value isn’t in the proper format (sometimes it shows a percentage value instead of a number). Converting Percentage Back to General Values

In case you do not want this to happen, you can convert the formula into values (i.e., remove the formula and only keep the values). Note that the result of this formula is dynamic, which means that in case you change the Sales value or the Commission percentage value, it would automatically update. In the above formula, instead of calculating the percentage value that we need to multiply with the number, we use the value of the initial sale (in cell B2) and subtract the commission sales value (given by B2*C2) from it. You can also use the below formula: =B2-B2*C2

Since 100% is equal to 1, to deduct a specific percentage value from a number, we first calculate the deducted percentage value by subtracting the percentage value from 1, and then multiplying it with the number.

Formula in excel to subtract