Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiply A by 1000 record results in B
how do I multiply the values in column A by 1000, and put the results in
column B |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiply A by 1000 record results in B
"Mother Goose" wrote: how do I multiply the values in column A by 1000, and put the results in column B If the first cell happens to be A1, the in B1 you would enter: =SUM(A1*1000) and hit enter. To apply this formula to the rest of the B column you could select the B1 cell, put the pointer on the small square in the lower right-hand corner of the cell, and drag down the column. This will apply the formula that you entered in the B1 cell to all the cells that you drag down to. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiply A by 1000 record results in B
=A1*1000
and copy down -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Mother Goose" wrote in message ... how do I multiply the values in column A by 1000, and put the results in column B |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiply A by 1000 record results in B
The SUM function is unnecessary here and can be dispensed with altogether,
eg =A1*1000. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------*------------------------------*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------*------------------------------*---------------- "Steve G" <Steve wrote in message ... "Mother Goose" wrote: how do I multiply the values in column A by 1000, and put the results in column B If the first cell happens to be A1, the in B1 you would enter: =SUM(A1*1000) and hit enter. To apply this formula to the rest of the B column you could select the B1 cell, put the pointer on the small square in the lower right-hand corner of the cell, and drag down the column. This will apply the formula that you entered in the B1 cell to all the cells that you drag down to. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
identify first date a record appears | Excel Worksheet Functions | |||
abdualmohsn | Excel Discussion (Misc queries) | |||
Record data on two lines | Excel Discussion (Misc queries) | |||
Function Help | Excel Worksheet Functions | |||
Amortization Schedule | Excel Worksheet Functions |