how do I multiply the values in column A by 1000, and put the results in
column B
how do I multiply the values in column A by 1000, and put the results in
column 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.
=A1*1000
and copy down
--
HTH
Bob Phillips
(remove nothere from the email address if mailing direct)
"Mother Goose" <[email protected]> wrote in message
news:[email protected]...
> how do I multiply the values in column A by 1000, and put the results in
> column 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 [email protected]> wrote in message
news:[email protected]...
>
>
> "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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks