You can learn how to multiply numbers in excel.If you want to add two or more numbers to one cell, you can do it against another.
Step 1: Open the spreadsheet.
The green app has a white "X" on it.To continue, you need to click on either PC or Mac.If you want to open an existing presentation in excel, double-click it.
Step 2: You can click a cell.
You can type into it if you select it.
Step 3: You can type into the cell.
The equals sign is used to start all formulas.
Step 4: The first number should be entered.
This should follow the symbol with no space.
Step 5: After the first number, type *.
The number you want to add before the number that comes after it is indicated by the symbol.
Step 6: The second number should be entered.
If you first entered a 6, your formula would now look like.As long as the "*" symbol is between the numbers you want to multiply, you can repeat this process with as many numbers as you like.
Step 7: Press enter.
It will run your formula.Clicking the cell will show the product of the formula in the address bar, but not the actual formula.
Step 8: Open the presentation.
Double-clicking an excel document will open it in excel.
Step 9: Click a cell.
You can type into it if you select it.
Step 10: You can type into the cell.
The equals sign is used to start all formulas.
Step 11: You can type in another cell's name.
This should go after the "" with no space.A1's value is the first number in your formula if you type "A1" into the cell.
Step 12: After the first cell name, type *.
The symbol indicates that you want to add the value before and after it.
Step 13: You can type in a different cell's name.
The second cell's value will be set by this.If you typed "D5" into the cell, it would make your formula look like this.You can add more than one cell name to this formula, but you will need to type "*" between subsequent cell names.
Step 14: Press Enter.
This will show you the result in your cell.The formula itself will be displayed in the address bar when you click the cell with the formula result.
Step 15: You can open an excel presentation.
To open an excel document, double-click it.
Step 16: Click a cell.
You can type into it if you select it.
Step 17: You can typePRODUCT into your cell.
The command indicates that you want to combine items.
Step 18: You can type in the first cell's name.
The cell at the top of the range of data should be this one.You could type "A1" here.
Step 19: The type is:
.The colon symbol indicates to excel that you want to multiply everything from the first cell through the next cell.
Step 20: Write in another cell's name.
If you want to add all the cells from the first cell to this one, this cell must be in the same column.The formula would be set up if you typed "A5".
Step 21: Then press Enter.
If you hit enter after the last parenthesis, you will see the result in your selected cell.The value in your selected cell will also change if you change the contents of a cell within the multiplication range.