increase column by %

G

Guest

I need to increase a price list by 5%. I must also round up the numbers to
the next $
 
G

Guest

David

I need to do this function for an entire column not just one cell, do you
have an answer ?
 
D

Dave Peterson

Insert a new column adjacent to the original column.
Put that formula (or one similar to it) in the top cell of that new column
Drag it down as far as you need.

Select that range
edit|Copy
Select the original range
edit|Paste special|values

And delete the helper column.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Roundup an entire column 6
how do i increase the value of numbers in a column by a percentage 5
Need to increase price by % and rounding up and down 5
How to increase all prices in price sheet by certain percent? 6
Add Same in amount in whole Column 21
Can I increase an entire column by a percentage? 4
Excel 2
Increase by percentages 6

Top