| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
increase column by %
I need to increase a price list by 5%. I must also round up the numbers to
the next $ |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
increase column by %
=ROUNDUP(A1*1.05,0)
-- David Biddulph "Boss Mary" <Boss wrote in message ... I need to increase a price list by 5%. I must also round up the numbers to the next $ |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
increase column by %
David
I need to do this function for an entire column not just one cell, do you have an answer ? "David Biddulph" wrote: =ROUNDUP(A1*1.05,0) -- David Biddulph "Boss Mary" <Boss wrote in message ... I need to increase a price list by 5%. I must also round up the numbers to the next $ |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
increase column by %
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. Boss Mary wrote: David I need to do this function for an entire column not just one cell, do you have an answer ? "David Biddulph" wrote: =ROUNDUP(A1*1.05,0) -- David Biddulph "Boss Mary" <Boss wrote in message ... I need to increase a price list by 5%. I must also round up the numbers to the next $ -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Increase whole column by same percentage | Excel Discussion (Misc queries) | |||
| Can I increase an entire column by a percentage? | Excel Discussion (Misc queries) | |||
| can I increase excel column numbers to more than 256? | Excel Discussion (Misc queries) | |||
| Increase Column D by 10% | Excel Discussion (Misc queries) | |||
| increase all values in a column by a percentage | Excel Worksheet Functions | |||
Linear Mode
