how to subtract using relative cell reference excel 2013

This cell does not change no matter where the formula is copied. We will use Cell E4 as the absolute cell reference. The number we will subtract is an absolute reference with the dollar sign so we can copy down the formula. We can subtract a number from numbers in a column.

We will drag the fill handle tool (the small box at the bottom-right when you click Cell F4) to enter the formula into the entire column.įigure 7 – Subtract Columns in Excel Subtracting the same number from a column of numbers.To subtract columns row by row, we will click Cell F4 and insert the formula: =D4-E4.We will then double-click on the small box at the bottom-right of Cell F4 and drag down to Cell F19.įigure 6 – Subtracting multiple cells in Excel using the SUM function How to Subtract Columns in Excel We can get the result for the other cells in Column F automatically by clicking Cell F4. We will click on Cell F4 and insert the formula: =D4-SUM(E5:E7). With this formula, we will add the values in range E5 to E7 and subtract the result from Cell D4. We will separate all the cells with a minus sign as shown below.įigure 5 – Subtract multiple cells from one cell using a minus sign Subtract Multiple Cells from one cell using the SUM function 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.

How to subtract using relative cell reference excel 2013