In excel I have four columns all containing 500 cells. These cells represent
wholsale pricing. I want to muliply each column by 2 so they represent
retail pricing.
Robert
In excel I have four columns all containing 500 cells. These cells represent
wholsale pricing. I want to muliply each column by 2 so they represent
retail pricing.
Robert
Back u or save your data FIRST!
then in an empty cell outside your 4X500 matrix
enter the number 2.
Copy this same cell (containging the Value 2).
Highlight the full range A1:D500,
then click on the Menu - Edit, Paste-Special,
Click the Multiply button, then OK
erase the cell containing the 2.
HTH
"Robert" wrote:
> In excel I have four columns all containing 500 cells. These cells represent
> wholsale pricing. I want to muliply each column by 2 so they represent
> retail pricing.
>
> Robert
Put 2 in an empty cell
copy that cell
select your range
edit|paste special|multiply
clean up that 2 in that cell.
Robert wrote:
>
> In excel I have four columns all containing 500 cells. These cells represent
> wholsale pricing. I want to muliply each column by 2 so they represent
> retail pricing.
>
> Robert
--
Dave Peterson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks