Basically Excel is a program that works as an array of rows and columns divided by squares and is focused on creating, modifying and managing spreadsheets. In this way, it is considered an ideal tool to tabulate and organize information effectively, as well as to insert data in order to handle, interpret and store it.
Thanks to this, it is a valuable resource in business areas, especially in administration and accounting environments. This, due to the numerous functions and tools it provides users. Thus, it is an alternative suitable for work with numeric data and perform calculations with mathematical utilities.
Therefore, Microsoft Excel allows you to do basic arithmetic calculations and use more complex mathematical functions, according to the requirements of each user. Of course, among these computations, we find the option to multiply data in cells easily. Next, we show you how.
What are the formulas to multiply all kinds of data in Microsoft Excel?
While it is true, through the "Formulas" tab Available in the program's options bar, you can find a host of functions with which to perform useful calculations and operations, for different purposes. In this sense, one of the most widely used types of formulas, are the "Mathematics and trigonometrics". So, from this menu, you can get the specific function to multiply all kinds of data within a spreadsheet in Excel.
Which is known as "Product" or "Product" and it has the ability to multiply all the numbers given as an argument, so return the proceeds of the operation in question. Additionally, you can also make use of an established mathematical operator for this type of calculation. Which is known as Multiply and basically it's about use the asterisk sign (*). Being this, a much more manual method to multiply digits in Excel, compared to the function noted above.
Steps to perform multiplication of data in a cell in Microsoft Excel
In view of what to do multiplications in Excel it's so essential it's worth knowing how it should be done, correctly.
As a consequence, we proceed to explain each of the steps to follow, in order to obtain the product of certain calculations, based on whole numbers, with decimals or with percentages:
Numbers
This type of multiplication can be carried out by means of the function "Product" available in the menu "Formulas> Mathematics and trigonometrics".
Next, we show you how to do it:
- To start, access the Microsoft Excel document where the numbers to be multiplied are exposed Or, failing that, open a blank spreadsheet and enter the data as you wish.
- Then from the tab "Formulas" on the ribbon, look for the Function Library group and there, click on "Mathematics and trigonometry".
With Decimals
When it comes to decimals, you can also do the multiplication operations by means of the "PRODUCT" function. However, there is a simpler method to obtain this type of results in excel.
Which admits both integers and decimals and here we show you how this procedure is carried out:
- Initially, enters the Excel document that contains the decimal numerical data to multiply Or, failing that, proceed to create a spreadsheet with these values.
- Thereafter, locate the cell in which you prefer to display the result of the multiplication and there, you must fix the mouse cursor to start the Turkish with the mathematical operator Multiply or asterisk (*).
- Then, manually, enter the identification of each cell to multiply, separated by an asterisk. Specifically, as follows: = B5 * C5 * D5 * E5. That is, as shown in the image.
- Once you have entered all the cells required to obtain the product, just hit the enter key And so, you will see the result based on the decimal numerical data.
However, if there are many cells that you have to multiply, it is recommended to use the function "PRODUCT" in Microsoft Excel. Since, this is more practical in such cases.
With percentages
In this case, the multiplication procedure it is a little different, due to the process that must be executed. However, it does not have any kind of complication and so you can do it correctly.
Here's how to multiply data from a spreadsheet by a percentage:
- To exemplify this procedure, we will consider a table of numerical data that must be multiplied by a certain percentage. As a consequence, we punctuate these digits in a column and next to it, the percentage to be taken into account will be entered.
- Once you put all the numbers to multiply by percentage in a column and write that percentage in an empty cell (as shown), it is necessary that copy that number using the keyboard shortcut "Ctrl + C".
Having done the above, proceed to select the range of cells where the values are located. multiply. In this case, dragging column B3 from top to bottom: B8.
- Then right-click on the cell selection and among the options displayed, choose "Paste special" (without accessing the menu contained in the arrow next to that option).
