I have a spread sheet that I use for a price list and we want to raise all the prices 25%. All prices are located in column "C".
Is there a way to raise the prices of the entire column with one command or function?
Thanks in advance.
Scott
I have a spread sheet that I use for a price list and we want to raise all the prices 25%. All prices are located in column "C".
Is there a way to raise the prices of the entire column with one command or function?
Thanks in advance.
Scott
Scott, put 1.25 in an unused cell, copy it, select the range you want to
change and right click paste special, select multiply
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"focker" <[email protected]> wrote in
message news:[email protected]...
>
> I have a spread sheet that I use for a price list and we want to raise
> all the prices 25%. All prices are located in column "C".
> Is there a way to raise the prices of the entire column with one
> command or function?
>
> Thanks in advance.
>
> Scott
>
>
> --
> focker
> ------------------------------------------------------------------------
> focker's Profile:
http://www.excelforum.com/member.php...o&userid=31554
> View this thread: http://www.excelforum.com/showthread...hreadid=512483
>
Thank you SO much!
Your welcome
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"focker" <[email protected]> wrote in
message news:[email protected]...
>
> Thank you SO much!
>
>
> --
> focker
> ------------------------------------------------------------------------
> focker's Profile:
http://www.excelforum.com/member.php...o&userid=31554
> View this thread: http://www.excelforum.com/showthread...hreadid=512483
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks