PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES
Mathematical operations are the basic tasks of any spreadsheet application.
Similarly , we can perform all the basic operations such as addition, subtraction, multiplication, division etc. in the Google Sheets.
The operations can be performed with the help of simple operators as well as with the help of functions.
In this article, we would focus on the Subtraction in Google Sheets with the help of operators and functions.
The subtraction operator is simply added in the front of the value to make it negative.
For Example
If we apply a minus (-) in front of 5, The number will become -5.
THE MINUS OPERATOR SIMPLY SUBTRACTS THE SECOND NUMBER FROM THE FIRST NUMBER. FOR EXAMPLE A-B MEANS B IS SUBTRACTED FROM A.
Suppose, we have two numbers X and Y.
Value of X is 12 and value of Y is 7.
If we want to subtract the numbers in google sheets, we would write the formula as
=CELL ADDRESS OF X – CELL ADDRESS OF Y.
The result will be the value equal to X-Y.
Let us take a few examples to try this on Google Sheets.
Let us find out the difference between two numbers.
NUMBER 1 | NUMBER 2 | |
EXAMPLE 1 | 321 | 54 |
EXAMPLE 2 | 9874 | 56 |
Let us understand the working of the formula used.
For example 1, we used the formula as
= D7- E7.
D7 is the first number.
E 7 is the second number, which is going to be subtracted from the first one.
– is the operator which will act for the subtraction of the second number.
There is a dedicated function named MINUS which can be used to subtract second number from the first one.
SYNTAX OF MINUS FUNCTION
=MINUS( First number , Second number )
First Number is the number from which we’ll be subtracting.
Second Number is the number which will be subtracted from the first number.
Let us take a few examples to try MINUS FUNCTION.
NUMBER 1 | NUMBER 2 | |
EXAMPLE 1 | 321 | 12 |
EXAMPLE 2 | 654 | 87 |
EXAMPLE 3 | -12 | -150 |
EXAMPLE 4 | -50 | 87 |
We'll find out the result of all the four examples using MINUS function.
The generalized formula used is
=MINUS( THE SUBTRACTING NUMBER, THE NUMBER WHICH IS BEING SUBTRACTED ).
For example 1,
We have used the formula as =MINUS(D19, E19)
D19 contains the number from which we are going to subtract the second number which is present as the second argument i.e. E19.
Similarly, all the examples will subtract the second number from the first number as per the standard arithmetic rules.
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE