how do i multiply a column by a percentage without blank cells being replaced by 0 in
i have ried the following to change the percentage of the collumn, but all the blank cells atomatically turn to zero's...
help please?:
Consider this scenario: Your company's product price list stored in a worksheet. Your boss informs you that, effective immediately, all prices must be increased by 5 percent.
You could create some formulas to do the math, and then convert the formulas to values, and then copy and paste the new prices over the old prices. Or, you could use this more efficient method:
1. Enter 1.05 into any blank cell. This is the "multiplier" that will increase the prices by 5 percent.
2. Select the cell you used in Step 1, and choose Edit, Copy or press Ctrl-C.
3. Select the range of values to be changed, and choose Edit, Paste Special to display the Paste Special dialog box.
4. Choose the Multiply option and click OK.
Voilà! The values are changed in an instant. You can then delete the cell that contains the 1.05 multiplier.
Note that the Paste Special dialog box lets you carry out other mathematical operations--like add and subtract, for instance--so you can use this technique for a variety of other calculations.
Hold down Ctrl and only select the fields you want.
Messy but cant see another way unless someone else comes up with something.
Regards
Special-K
I rarely return to a problem once I've answered it so make sure you clearly define what the trouble is.
thanks, but ii think it would be qicker just to delete the zeros.
regards
1) Enter your multiplication value in an empty cell
2) Copy it
3) Highlight your range of prices including blank cells
4) Press F5, click SPECIAL > Constant > OK
5) Edit > Paste Special > Multiply > OK
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
wow...
worked a treat
great, thanks.
wow...
worked a treat
great, thanks.
If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks