How To Subtract In Excel

How To Subtract In Excel

Excel has been the digital statistical and mathematical approach for the analysis of data and modification. Various mathematical functions and laws are used in excel. Some of them are

  1. Addition
  2. Subtraction
  3. Multiplication
  4. Average
  5. Derivatives
  6. Mean, median ,mode
  7. Division
  8. And many more

These modules can be executed using two modules. Either by using the predefined clicks or by using the functions (Using variable mathematics.)

Subtraction basically means the difference between two things. The direct difference is calculated based on the internet number line, time formats, constant and also keeping in the mind the conversions from higher unit to lower and lower unit to higher. Here we will look into the ways we will be doing subtraction in excel.

Steps to Subtract in Excel using the function = sign

Step 1: Enter the values subjected to subtraction in two different columns.

Step 2:  Now very simple give an = sign in the third column where you need your answer for subtraction.

Step 3: Here you need to give the column names with a minus – sign in between.

For instance: =A1-B1

Where A1: name of column 1

B1: name of column 2.

Using this simple algorithm one could easily subtract the two different values in Excel.

Steps to subtract time in Excel, importantly changing AM to PM and vice versa

During the time subtraction, it is crucial to keep in mind the time formats. Therefore the necessary things to be taken under consideration are

  1. Time format: whether it is a 24 hour clock or 12 hour clock.
  2. Type of input values: while entering time we have many ways to accomplish the task like by entering hour and minute. Some give the entire minute format, while some add seconds as well.
  3. Uniformity of data: in case you are performing multi row subtraction or time Formatting with a single formula make sure that the data is of similar type.

Follow the similar steps to subtract the two values just make sure to add p or PM and a for AM after the values. Consider the below example for better understanding.

A1: 12:34 p.      B1: 0.34 p.       C1: =A1-B1

Looking at this example hope you got the insights.

Steps to subtract multiple columns in Excel

As mentioned for the basic two-variable subtraction we allocated two column names and by using the equal sign = and minus sign – we successfully deduced the difference value between the two.

In the case of multiple cells, the rule goes the same. Here you need to enter the values subjected to subtraction in different columns irrespective of the order.

Now while deducing the difference make sure you enter the correct sequence of differences.

For instance, if a user has 5 columns to be subtracted one after the other say A1, A2, A3, A4, A5 so the function/formula goes like =A1-A2-A3-A4-A5.

Here a user can change the sequence of columns on his/her choice.

Also Read:

Solve a complex formula having subtraction in it

Every formula in Excel goes after the = sign. If you have the subtraction or any other priority step to be done before the BODMOS implementation, then add the brackets to those units.

If a user needs to do subtraction in a complex function on a priority basis then for reference look at the below two inputs to the excel.

  1. A1*B1+(B2-A1)
  2. (A1-B2)-A2

Leave a Reply

Your email address will not be published. Required fields are marked *