Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
What is the easiest way to muliply numbers in Excel
What is the easiest way to multiply numbers in excel and how can I make the
calculations repeat the process for numerous rows with different numbers to be calculated? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
What is the easiest way to muliply numbers in Excel
If you want to multiply A2 and B2, use the formula =A2*B2. If you want to
do the same on each row, copy the formula down as far as you need it. -- David Biddulph "ManhattanRebel" wrote in message ... What is the easiest way to multiply numbers in excel and how can I make the calculations repeat the process for numerous rows with different numbers to be calculated? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
What is the easiest way to muliply numbers in Excel
Thank you..I know how to multiply cells now but how can I copy fomula and
apply it to other rows? "David Biddulph" wrote: If you want to multiply A2 and B2, use the formula =A2*B2. If you want to do the same on each row, copy the formula down as far as you need it. -- David Biddulph "ManhattanRebel" wrote in message ... What is the easiest way to multiply numbers in excel and how can I make the calculations repeat the process for numerous rows with different numbers to be calculated? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
What is the easiest way to muliply numbers in Excel
Method 1. Select the cell with the formula. Copy. Select the rest of the
Range. Paste. Method 2. Select the bottom right hand corner of the cell with the formula and the cursor turns into a square fill handle. Drag that fill handl;e down the rest of the range. Method 3. If your multiplication formula is in a cell adjacent to a range of data (if it is in cell A2 in this case), double-clicking on the fill handle (see method 2 above) will automatically fill the formula down as many rows as you have contiguous data in the adjacent column. If you are struggling with Excel basics, you may need to take a basic Excel training course or tutorials, read a book on introduction to Excel, and/ or use the newsgroup: microsoft.public.excel.newusers. -- David Biddulph "ManhattanRebel" wrote in message ... Thank you..I know how to multiply cells now but how can I copy fomula and apply it to other rows? "David Biddulph" wrote: If you want to multiply A2 and B2, use the formula =A2*B2. If you want to do the same on each row, copy the formula down as far as you need it. -- David Biddulph "ManhattanRebel" wrote in message ... What is the easiest way to multiply numbers in excel and how can I make the calculations repeat the process for numerous rows with different numbers to be calculated? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
What is the easiest way to muliply numbers in Excel
Thank you.. With your initial help, i figured out how to apply the formula to
other rows before you could reply again. "David Biddulph" wrote: Method 1. Select the cell with the formula. Copy. Select the rest of the Range. Paste. Method 2. Select the bottom right hand corner of the cell with the formula and the cursor turns into a square fill handle. Drag that fill handl;e down the rest of the range. Method 3. If your multiplication formula is in a cell adjacent to a range of data (if it is in cell A2 in this case), double-clicking on the fill handle (see method 2 above) will automatically fill the formula down as many rows as you have contiguous data in the adjacent column. If you are struggling with Excel basics, you may need to take a basic Excel training course or tutorials, read a book on introduction to Excel, and/ or use the newsgroup: microsoft.public.excel.newusers. -- David Biddulph "ManhattanRebel" wrote in message ... Thank you..I know how to multiply cells now but how can I copy fomula and apply it to other rows? "David Biddulph" wrote: If you want to multiply A2 and B2, use the formula =A2*B2. If you want to do the same on each row, copy the formula down as far as you need it. -- David Biddulph "ManhattanRebel" wrote in message ... What is the easiest way to multiply numbers in excel and how can I make the calculations repeat the process for numerous rows with different numbers to be calculated? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to muliply | Excel Worksheet Functions | |||
Easiest way to remove text from a cell that has text and numbers? | Excel Discussion (Misc queries) | |||
What is the quickest and easiest way to learn Excel? | New Users to Excel | |||
A formula that is: if the sum is this, then muliply by this? | Excel Worksheet Functions | |||
muliply | New Users to Excel |