We will click on Cell F4, type the equality sign and click on the cells we wish to subtract from Cell D3.

We will then double-click on the small box at the bottom-right of Cell F4 and drag down to Cell F19.įigure 4 – Subtract cells in Excel How to Subtract Multiple Cells from One Cell in Excel Using Minus Sign

Now, we can get the result for the other cells in Column F automatically by clicking Cell F4. Next, we will enter the formula below into Cell F4 and PRESS ENTER.We will click Cell F4 where we wish to display our result.We can use the minus sign to subtract the value of one cell from another cell in excel. We will need to input the values manually. It is important for us to know that this is a tedious procedure since we cannot automatically copy down the formula from Cell F4 to Cell F19. In Cell F4 where we want the result to appear, we will type the equality sign, the first number, followed by the minus sign, and then, the second numberįigure 2 – Subtracting two numbers in excel with the minus sign.Therefore, we will use the formula and steps below:

The minus sign (-) is the simplest function used. These easy steps can be executed by all levels of Excel users from novice to expert.įigure 1 – Applying the subtract function in Excel Using Subtraction Formula without Subtract FunctionĮxcel does not have a subtract function. However, in this article, we have detailed foolproof ways of subtracting numbers, dates, time, percentages and matrices in excel and google sheets. How to Subtract in Google Sheet and ExcelĮxcel does not have a subtract function.

Excel subtraction formula whole column