How to Add, Subtract, Multiply or Divide in Excel Manually or with Formulas?

How to Add, Subtract, Multiply or Divide in Excel Manually or with Formulas?

How to Add, Subtract, Multiply or Divide in Excel Manually or with Formulas?

Microsoft Excel is one of the most used tools in the Microsoft Office office suiteWith this tool you will be able to calculate VAT on products, create graphics, record data and many more applications for office work.

Nevertheless. To perform many of these tasks, it is essential to know how to do basic operations like add, subtract, multiply or split manually in Excel. Continue reading and see how to do it.

How to do addition, subtraction, multiplication or division manually in Excel?

As we have already mentioned, it will be fundamental and useful know the procedure to perform basic operations math in Excel; as it is the basis for performing various calculations and more complex tasks. Here are the methods in which you can fill in your cells to complete the operations:

In a single cell

Depending on the circumstances, you will have to perform some operations separately or together in the same cell, in this case you must follow the following procedure:

  • To carry out sums in the same cell, it will be enough to place the numbers or quantities that you wish to add by inserting said quantities with the symbol “+”; For example, suppose you want to add the quantities 15, 8, 23 and 46. You must place in the cell where you want to perform the operation, the following expression: “= 15 + 8 + 23 + 46”Pressing the “Enter” or “Enter” key will result in the number “92”.
  • The subtraction in the same cell, they will complete it in a similar way to the procedure that we have explained with the addition, since the difference will be that you must use the symbol “-” instead of the “+”. Example, to subtract 15.8 and 2 you must place in target cell “= 15-8-2”, the result will be “5”.
  • You will obtain the multiplication by placing the symbol “*” in the middle of the quantities. If you want to multiply 12, 5 and 4. Put the expression “= 12 * 5 * 4” in the destination cell, and the result will be “240”.
  • To divide, the symbol to use is “/”, in this case if you want to divide the quantities 240 and 6 for example, place in the corresponding cell “= 240/6”, the result will be “40”.
  • Finally, you can perform combined operations (Algebraic Operations) as it is known in mathematical terms in the same cell. To do this, take into account the hierarchy of operations (multiplication and division first, and addition and subtraction last) or, use parentheses to determine the order of operations. For example, “= 2 + 4 * 3-8 / 2”, this operation in Excel will result in the number “10”. Now if you use “= (2 + 4) * 3-8 / 2”, it will be “14”.
Read This Now:   Black desktop background display issue in Windows 11

Adding, subtracting, multiplying, or dividing cells

Another option that you will have is to carry out operations of addition, subtraction, multiplication and division of different cells; To do this process manually you must go to the destination cell, and point to the cells whose content you want to perform the operations and place the symbol of the corresponding operation (“+”, “-“, “*” or “/”). For example, if you want to add cells A2, A3, A4 and A5, put in the destination cell “= A2 + A3 + A4 + A5”.

The difference between this procedure and the previous one is that you will have a expression that will change depending on the quantities or numbers that are in the reference cells (A2, A3, A4 and A5).

Follow the same procedure that we showed in the previous section for the rest of the operations, but the difference will be that instead of place fixed values, you must place the reference cells where the values ​​you want to operate will be.

Read This Now:   How to install two operating systems on a pc linux and windows 7 - Easy Steps

view of calculation of algebraic operation in the same cell in excel

For example, a operation combined with named cells It can be “= A2 + A3 * A4-A5 / A2”, with this we are telling Excel to multiply the content of A3 by A4, divide the content of A5 by A2, and finally take the value of A2 and add it the result of the multiplication and subtract the value of the division.

In relation to this process of cell operations you will have the possibility to operate on cell ranges such as subtracting quantities and ranges in Excel. Although you will not only have the possibility to subtract ranges, but to perform other operations.

What are the functions that allow you to perform basic math operations in Excel?

With the passage of time, Microsoft Excel incorporates more tools that allow making histograms and polygons of frequencies, graphs or advanced calculations of various kinds. However, it maintains the basic and elementary functions of simple calculus in all its versions, such as:

Sum

The sum function is a resource that provides Microsoft Excel to help you perform the addition operation on a set of cells, the application of this resource will be very useful and valuable when you have many cells with data that you need to add.

Read This Now:   How to Install Disney Plus on Smart Tv Lg 2015 - Easy Steps

To apply this function correctly, you must place in the destination cell “= Sum (Range_of_cells)”, where the cell range argument is all those cells that contain the values ​​of interest. “= Sum (A2: A20)”.

image view with use of sum function in excel

Product

Multiplication is conceived in Excel as the “Product” function, with it you can perform multiplication operations on cells or cell range you want to operate. For example, if you have cells from B2 to B6, and you want to multiply them, put in the destination cell “= Product (B2: B6)”.

Now, if you want to multiply those cells and add another that is not successive in the multiplication, you can put “= Product (B2: B6; B8)”. With the previous expression we tell Excel to multiply all cells from B2 to B6 and cell B8, the key for skipping cell B7 is to place the semicolon symbol (;).

As you will see the colon (:) operates or tells Excel to take the entire range; while the semicolon indicates that it must take a specific cell. You will have already noticed how simple it is perform basic operations in Excel, both in the same cell, and in range.

It is also simple to do combined operations and even work with cell ranges using functions. For more information regarding basic operations, you can consult the official Microsoft page.


Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /home/gamefeve/bitcoinminershashrate.com/wp-includes/functions.php on line 5373

Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /home/gamefeve/bitcoinminershashrate.com/wp-includes/functions.php on line 5373