Learn how to use a complex program such as Excel it's a bit like going back to school. You have to start from the basics, from the most elementary things, to then deepen the more complex topics and, slowly, become familiar with all the advanced functions offered by the software.
With this in mind, today I want to continue the work of approaching Excel that we started with my post on how to use Excel and show you in detail how to multiply in excel taking advantage of the main options made available by the program. It's a simple operation, I know, but if you don't learn mechanics like this well, you're unlikely to become an Excel expert.
I will use for the tutorial Office 2022, which is available for both Windows and macOS. In any case, the information contained in the guide can be applied without any problem even to older versions of Excel, and certainly also future ones: at most it can change the position of a button in the toolbar, but the formulas to be used and the steps to be taken accomplish are always the same. Good reading and good fun, or good work, depending on your point of view!
- Simple multiplication
- How to multiply cells in Excel
- How to multiply one column by another in Excel
- How to multiply a column by the same number
- How to multiply all cells by a constant in Excel
- How to multiply a column by a percentage
- How to multiply hours by euro in Excel
- How to multiply in Excel for smartphones and tablets
- How to multiply in Excel Online
Let's start this quick guide on how to multiply in excel with simple multiplications, those that will allow you to view the product of two numbers typed in the cell itself in a given cell.
To perform a simple multiplication in Excel, all you have to do is click on the cell of the spreadsheet in which you want to show the product of the multiplication, type the symbol equal (=), the two numbers to multiply interspersed with a asterisk (*) and press the button Submit of the PC keyboard.
For example, if you want to multiply numbers 8 e 8 (the number will then be displayed in the cell 64), all you have to do is click on the cell of the spreadsheet in which you want to show the product of the multiplication, type = 8 * 8 and press the key Submit of the PC keyboard.
How to multiply cells in Excel
If you want to multiply the numbers contained in two or more different spreadsheet cells, all you have to do is create an expression using the coordinates of the cells to be multiplied.
For example, if you want to multiply the digits in the cells A1, B1 e C1, you need to click the cell where you want to display the multiplication product, type = A1 * B1 * C1 and press the key Submit of your PC keyboard. Easier to do than explain, I assure you.
Alternatively, if you want to do this first, you can also type the formula PRODUCT in the cell in which to display the multiplication product and select the cells to multiply by holding down the key Ctrl (Windows) or cmd (Mac) on the computer keyboard.
If you want multiply all the values found in a column of the spreadsheet, use the formula = PRODUCT (A: A) where instead of A: A you have to enter the letter of the column you want to multiply (ex. B:B if you want to multiply the values of column B, C:C if you want to multiply the values of column C and so on).
How to multiply one column by another in Excel
You would like it multiply the values in one column by the values in another? You can do this too, and it's super simple! Click on a cell that is in the same row as the first cell to multiply (ex. C2 if you need to multiply the values starting from the cells A2 e B2), type the formula = A: A * B: B and press the key Submit on your PC keyboard. Of course, instead of A: A e B:B you have to type the letters corresponding to the columns that contain the values you intend to multiply.
When the operation is completed, in the cell where you entered the formula, you will see the product of the multiplication between the first two cells of the selected columns appear. To make the products of the other cells appear, you need to double-click the square that appears at the bottom right of the cell where you entered the formula.
How to multiply a column by the same number
You have now learned the basic function for multiply in Excel, but what if I wanted to multiply a series of numbers arranged in a column by the same number? Nothing simpler. Just double-click on the cell adjacent to the one containing the value you want to multiply (for example the cell B2 for a value in the cell A2).
Once this is done, type the formula = A: A * [number]. In the place of [number] you must indicate the number you want to indicate in the multiplication. For example, if you want to make the product of all the values of the column A for the number 5, type the formula = A: A * 5. Then drag the square below the cell, to repeat the formula on all cells below.
In this regard, I also want to point out another procedure by which to multiply multiple cells of a spreadsheet by the same number: type the number by which you want to multiply the other digits in a cell of the spreadsheet, select the cell with the mouse and click on the button Copy present in the Excel toolbar.
At this point, select with the mouse (holding down the left button) the cells with the digits you want to multiply by the number copied previously and select the item Paste special from the menu Paste (top left).
In the window that opens, put the check mark next to the item Multiply and click on the button OK to complete the operation. The numbers in the selected cells will be replaced by the multiplication results.
How to multiply all cells by a constant in Excel
After what I indicated in the previous chapter, let's see now how to replace a number with a real constant, in order to carry out the multiplication.
In the meantime, what you need to do is locate the constant in the Excel sheet. For example, let's say that all values are in the column A and that the constant is indicated in the cell G1. In this case, in order to proceed with the multiplication of all the factors present in the column A with the constant in G1, you need to use the following formula = A: A * $ G $ 1.
Specifically, you're going to use the del symbol dollar ($) both on the indication of the column of cell G1 and on that of the row, so as to block it. This operation is necessary to avoid that when dragging the formula into the underlying cells (using thesquare icon) the cell reference is not changed.
How to multiply a column by a percentage
How do we put it if you wanted to instead multiply a column by a percentage? Again, the operation to be performed is very simple.
Double click on a cell that is in the same row as the first cell of the column to multiply (ex. B2 if you need to multiply the values found in the column A and leave the cell A2), type the formula = A: A * [percentage] and press the key Submit on your PC keyboard. In the place of A: A you have to type the letter corresponding to the column that contains the values to multiply, while in place of [percentage] you must enter the percentage by which to multiply the column.
At this point, in the cell you selected, the result of the multiplication between the value of the first cell will appear (ex. A2) and the percentage indicated by you (eg. 5%). To make the result of the percentages relative to the other cells in the column appear, you need to double-click the square which is at the bottom right of the cell where you entered the formula.
If you intend to multiply a column by a percentage already contained in the spreadsheet, you can use the formula = A: A * $ B $ 1 where instead of A: A you must enter the letter corresponding to the column that contains the values to multiply and instead of $B$1 the coordinates of the cell that contains the percentage to be used for the multiplication (in this example it is B1, the dollar symbols are used to block the value to be multiplied and prevent Excel from automatically multiplying the cells of the same row, for example A3 with B3, A4 with B4 and so on).
If you need more information on how to calculate the percentage in Excel, take a look at the tutorial I wrote on the subject: inside you will find all the information and all the information you need.
How to multiply hours by euro in Excel
Let us now look at another example, namely the one relating to how to multiply hours by amounts in euros (or any other currency) in Microsoft Excel. After reading what has been explained in the previous chapters, performing this operation may seem like a child's play, but in reality it is not if you do not take into consideration some important factors.
Applying what we have learned so far, let's take as an example that you want to multiply the values in hours present in the column A for amounts in euros of the column B: in this regard you might think that it would be enough simply to use the formula of the product between the two values, to obtain the result in the adjacent cells (those of the column C). In reality, carrying out this procedure would obtain a clearly incorrect result, which would not correspond to what you could easily do manually.
The basic problem in miscalculation depends on a few factors: First, you need to set the time format for the values in column A. Via the drop-down menu at the top Generali (o custom), select the option Time. If a value in column A exceeds 24 hours, using the drop-down menu previously indicated, choose the option Other number formats and, in the screen that is shown to you, select the items Time> 37:30:55. For entering hours, follow the format [hours]: [minutes]: [seconds].
Once this is done, set the format Currency for the values in column B via the drop-down menu at the top Generali (o custom). You can also already set the cells of column C with the format Currency, as the result will be a currency amount.
Finally, you need to consider how hours are treated in Microsoft Excel - hours are automatically converted to days. For this reason, multiplication must also have the factor 24, in order to obtain the correct result.
In the light of what has been said and considered the proposed example, the formula to be used in the cell C2 is = A2 * B2 * 24 or = A: A * B: B * 24, so as to obtain the exact total amount with respect to the hours indicated. Then drag the formula through thesquare icon, to bring it back to all the cells below.
How to multiply in Excel for smartphones and tablets
As you most likely already know, Excel It is also available via app for Android (from the Play Store or from alternative stores) and iOS / iPadOS. You can use it for free on all devices that are 10.1 "or smaller (alternatively a subscription to Microsoft 365 is required).
If you have a smartphone or tablet that corresponds to the size characteristics above, you can download Excel simply by opening the store of your device, looking for Excel in the latter and pressing the button Installa / Ottieni located next to the application icon. Identity verification via Face ID, Touch ID, or Apple ID password may also be required on iPhones and iPads.
Once the download is complete, you will be able to create new spreadsheets, view existing ones and modify them as you wish. Documents can be saved (and uploaded) locally or from cloud storage services such as OneDrive, Google Drive e iCloud Drive (on Apple devices only).
For the rest there is not much to say, the Excel mobile app has a user interface very similar to that of Excel for computers (on smartphones to view the toolbar you have to press the icon of the pencil located at the top right) and the formulas to be used for multiplications are the same as those illustrated above for the desktop version of Excel.
How to multiply in Excel Online
If you prefer to work from a PC but don't have Microsoft Office at your fingertips, you can create, view and edit spreadsheets with Excel Online, the online version of Microsoft Excel which works directly from the browser and does not require any payment: you can use it for free with a simple access through a Microsoft account.
As well as Excel for smartphones and tablets, Excel Online does not include all the advanced functions of the standard version of Excel (the one that is installed with Office), but it supports multiplication and allows you to use all the formulas mentioned above. So, if you need to practice multiplication in Excel and you don't currently have Office installed on your PC, you can connect to Excel Online, log in with your Microsoft account, and work directly from your browser.
After working on a document in Excel Online, you can choose whether to leave the file on your personal OneDrive (therefore online) or to download it offline by going to the menu File> Save with nome of service.
To conclude, I would like to point out that other possible ones alternative a Microsoft Excel in which you can use the formulas for the multiplications seen above are LibreOffice, a free and open source productivity suite compatible with Windows, macOS and Linux and Google Sheets, Google's online platform for spreadsheets. Keep them in mind if you don't have the ability (or the desire) to use Microsoft Excel.