how to enter a subtraction formula in excel

It can also be done by entering or using cell references or addresses in the formula.Į.g., =B16-C16, in the below-mentioned example returns the value 4

Subtraction can be done by entering the numbers which you want to subtract directly into a formula, e.g., =6-4 results, or returns the value 2.

The subtraction sign in Excel is the dash (-), an arithmetic operator.

The formula is entered in a cell where you want the result to appear.

It should always begin with an equal sign (=).

The criteria for creating a formula for subtraction in Excel is

You can create a formula to subtract two or more numbers in Excel. Let’s check out how the SUBTRACT works in Excel. How to do Subtraction between Numbers and other Values in Excel The SUM function is also helpful in Subtraction, where it subtracts all the numbers given as a range of values in arguments and returns the desired output. It is an operation performed on a pair of numbers to obtain or derive a difference between two numbers. Subtraction is the opposite of the addition process. With the help of the dash (-) symbol, you can quickly subtract between numbers, cells, entire rows, and columns. The below mentioned arithmetic operators are used to perform the calculation in Excel. Excel functions, formula, charts, formatting creating excel dashboard & othersĮ.g., In problem 6 – 4 = 2, the number 6 is called the minuend, the number 4 is called the subtrahend, and the number 2 is the difference.Ĭurrently, there is no specific or inbuilt universal Subtraction function or formula in Excel to perform a subtraction between two numbers, you have to use the dash (-) or minus sign symbol, which is a subtraction sign or arithmetic operator to subtract between two numbers.

How to enter a subtraction formula in excel