How to multiply 2 cells in Excel
By
SpreadCheaters
Let’s assume you want to calculate how many items of a certain product you have in your warehouse. You have two columns, one with the number of shelfs and one with the number of products for each shelf. By multiplying the two cells you’ll obtain the number of a certain product in your warehouse. To multiply 2 cells in Excel proceed as follows.
Step 1 – Select the cell where to insert the multiplication
– Select the cell by clicking on it or with the keyboard arrows. A good choice can be to select the cell near the two you want to multiply, in order to have the result as close as possible.
Step 2 – Multiply the two cells
– Inside the selected cell write “=” to let the tool understand you want to insert a function;
– Select the first cell you want to multiply adding it to the function;
– Write “*” as multiplication operator;
– Select the second cell you want to multiply adding it to the function;
– Press enter to confirm the function.
