While it ’s not as gentle as tapping a few key on a calculator , you canuse Microsoft Excelto do simple mathematics , such as multiplying issue . for do this , you ’ll require to memorise Excel ’s language a bit . But do n’t worry , in this usher , we ’ll go over what you need to know as we show you how to multiply in Excel .
We ’ll review four different ways to breed in Excel : childlike multiplication within a cell , reproduce number from dissimilar electric cell , breed ranges of numbers , and multiplying each number of a column by a constant .
How to multiply within a cell
If you just want to execute simple times within a cell in an Excel spreadsheet , here ’s what you do :
Step 1 : fall into place on a cellular telephone .
tone 2 : typewrite the following ( with no spaces ) into that cell:=[any number]*[any telephone number ] .
For object lesson :
= 20 * 35
Step 3 : Then hit theEnterkey on your keyboard . ( Or click anywhere else on the spreadsheet . )
The formula you typed will immediately be replaced with the correct answer .
How to multiply numbers from different cells
If you have a data gear up and you need to reproduce numbers from it together ( as in numbers from different cell ) , here ’s how to do that :
whole step 1 : opt at least two numbers from your data set to multiply . Then come home on a blank cell .
Step 2 : In the blank cell , type the following:=[cell reference book for any number]*[cell acknowledgment for any bit ] .
= A4*A5
A cell character reference is a chromatography column letter combined with a quarrel numeral that refers to the cells of each of your desired number .
stone’s throw 3 : Then hitEnteron your keyboard . The correct response should forthwith replace the formula you typed in .
( You canlock cells in Excelto protect the contents , useful if the cells in interrogative sentence display the result of a recipe . )
How to multiply ranges of numbers via the Product function
you could also multiply cell reach ( ranges of number in your datum set ) . To do so , you ’ll use the PRODUCT function . Here ’s how :
footfall 1 : Choose where you need your range to begin and terminate . Then press a blank cubicle .
Step 2 : In that clean cell , type the following ( with no spaces):=PRODUCT([cell acknowledgment for starting time of range]:[cell reference for end of range ] ) .
= PRODUCT(A1 : A5 ) .
footstep 3 : Then murder theEnterkey on your keyboard . The correct reply should straightaway substitute the ware procedure you typed in .
How to multiply in Excel: Multiplying each number in a column by a constant
If you have a data point set and you need to breed each value in that set by a constant number , you could do that in Excel . Here ’s how :
footstep 1 : At the top of anew column , case in your desired constant numeral .
( In our deterrent example , the new column is vitamin B and the constant is 5 . )
Step 2 : At the top of the next raw column , type in the pursual with no space , using the cell reference for the first number in your data coif and your desire constant number:=[cell source for the first issue in data point set]*$[column missive for desired unvarying number]$[row turn for desire changeless number ] .
In our model , the next novel column is C and the formula would look like this : = A1*$B$1 .
Step 3 : Then hit theEnterkey on your keyboard . The correct answer should at once replace the formula you just type .
Step 4 : In Holy Order to get the right answer for all of the other number in your data set , just do the pursual :
tap the cell where you entered your formula and then pussyfoot over it until you see a black hybridizing icon , then click and hang back your convention down to the other cells in that column to copy it to them . Once you publish the mouse button , the right answers for each of the values in your data set should immediately appear as they did for the first economic value .
Microsoft Excel is an incredibly flexible piece of software program , capable of everything from basic math to advanced calculations for all personal manner of purposes from occupation to science and data analytic thinking . But if you want to keep things simple for now , why not learnhow to take off in Excel ?
