G Guest Jul 30, 2007 #1 I need to increase a price list by 5%. I must also round up the numbers to the next $
G Guest Jul 31, 2007 #3 David I need to do this function for an entire column not just one cell, do you have an answer ?
D Dave Peterson Jul 31, 2007 #4 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.
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.
