Increase prices in a column by 20 percent

[jimmiethegent]

I uploaded a image to show you what column it is. I need to increase the whole column by 20% but I have no idea how to do it. Please help!!

[jeffreybrown]

Hello jimmiethegen & Welcome to the Forum,

How about...

In a blank cells somewhere on the spreadsheet >> put 1.2 >> then copy...

Now highlight U2 to the end of the range >> right click >> pastespecial >> multiply >> Ok

[jimmiethegent]

Thanks that worked but the only problem now is that it is giving me values like 16.272. I need it to omit the extra character. So it would be 16.27 rather then 16.272. Is there a trick to that? Thank you so much for the help!

[FDibbins]

format to 2 decimal places?

[shg]

You'd need to use a formula that multiplies by 1.2 and rounds the result to two places. Then paste the results as values over the original data.

[jimmiethegent]

Ok that worked! Thank you all. One more question... Let say the prices are at $12.3 16.2 and so on. Is there a way to edit all to have 95 after the decimal. Changing them all to lets say $12.95 $16.95 in the column? That would finish my long time issue. Thank you everyone so much!!

Jimmie

[jeffreybrown]

Hi Jimmie,

Try...

=INT(A1)+0.95

[newdoverman]

You could try:

Please Login or Register  to view this content.

[jimmiethegent]

Where do I insert that? I'm such a rookie.

[jeffreybrown]

Please Login or Register  to view this content.

Hi newdoverman,

Two bugaboo's I see with this...

1) This makes the result as text, not a number
2) What if the number was 12.6?

[jeffreybrown]

Hi Jimmie,

You need to use a helper cell and enter the formula there then copy over the values as shg pointed out above...

Let's say 12.65 starts in column C. In the next open column =INT(C2)+0.95

Copy this down the entire column >> highlight column >> right click copy >> now move to column C >> highlight >> right click >> pastespecial >> values

It might even be worth just leaving column m as is and just use the helper column with the new data

D2 copied down >> =INT(C2)+0.95

Data Range

	C	D
2	16.54	16.95
3	13.22	13.95
4	3.1	3.95
5	12.31	12.95
6	14.88	14.95
7	10.62	10.95
8	10.88	10.95
9	16.78	16.95
10	14.8	14.95
11	17.41	17.95
12	3.88	3.95

[newdoverman]

Yah, that won't work. This seems to though. Enter in B1 and copy down the length of the data:

Please Login or Register  to view this content.

This will take everything from 1 cent over the dollar and round up to the 95 cents. It will also take the even dollar amount down to 96 cents and round it to 95 cents so. $10.00 will become 9.95 as will $9.99 and less.

[jimmiethegent]

My goodness! It worked! Thank you a million!! ha!