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.
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:
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:
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.
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.
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:
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.
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)”.
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.
Mining on RTX 3070. Overclocking, tuning, profitability, consumption: If you are interested in finding more…
Mining with GTX 1660, 1660 Ti, 1660 Super. Overclocking, settings, consumption, profitability, comparisons - If…
Mining with RTX 2070 and 2070 Super. Overclocking, profitability, consumption, comparison What the RTX 2070…
Mining with RTX 3060, 3060 Ti. Limitations, overclocking, settings, consumption, profitability, comparison Let's look at…
Alphacool Eisblock Aurora Acryl GPX-A (2022) with Sapphire Radeon RX 6950 XT Nitro+ Pure in…
In the ever-evolving landscape of business strategy, Bitcoin has emerged as a pivotal asset. With…
This website uses cookies.