Microsoft Excel - Adding 4% To Existing Price Column

**D.Jeppo** · 01-27-2020, 07:04 AM

Apologies if this has been solved elsewhere, i have not been able to find a similar thread.

Basically, I need to change prices on an existing pricing sheet to have a 4% increase to prices. Now, i already have a pricing sheet with prices on that will need to be changed, but also i will need to add additional prices to the list from time to time.

Is there a rule i can use to the prices column that will automatically add 4% to whatever amount i type in, so whenever i add a new price, instead of manually adding 4% to it, if i type in £250 say it will automatically add the 4% and change the price to that which i typed in without the need for additional columns?

**torachan** · 01-27-2020, 07:09 AM

I think you will need to use a UDF (user defined function) if you do not want to use another column.

**Sam Capricci** · 01-27-2020, 07:10 AM

you can do it with a formula, so if your price is 250 and is in cell A2 then =IF(A2="","",A2*1.04) so the new price would be 260.
But if you want to simply put a price in a cell and have it show as 260 instead of 250 then that might require VBA. So I'm not completely sure which you are saying.

**Pepe Le Mokko** · 01-27-2020, 07:13 AM

Administrative note
Please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version. Your profile does not indicate your version.
Thanks

**D.Jeppo** · 01-27-2020, 07:28 AM

Originally Posted by Sambo kid

you can do it with a formula, so if your price is 250 and is in cell A2 then =IF(A2="","",A2*1.04) so the new price would be 260.
But if you want to simply put a price in a cell and have it show as 260 instead of 250 then that might require VBA. So I'm not completely sure which you are saying.

My apologies, but it would be for when i add a new price to the sheet, if i type in 250 in a cell in the price column, it automatically changes the value in that same cell to include the 4% price increase.

I want to basically tell excel that any number i type in the price column, it is to automatically add 4% to it and over type that cell with the new total without the need for additional columns and formulas.

**jotpol** · 01-27-2020, 07:46 AM

To change existing prices simply copy cell with "1.04", select column with prices and paste spacial (check multiply)
Attachment 659727

For prices to be entered in the future: paste the following code in VBE (alt+F11, select proper sheet name)

Please Login or Register  to view this content.

You should change those lines:

Please Login or Register  to view this content.

**D.Jeppo** · 01-27-2020, 07:54 AM

Thanks. As someone that has never used this part of Excel before, what do I do when i have pasted this into VBE?

Not to worry, I have done it, thanks so much.

**KOKOSEK** · 01-27-2020, 08:00 AM

Try like:

Please Login or Register  to view this content.

@jotpol: small tweak:

Please Login or Register  to view this content.

@D.Jeppo - as Jotpol said, in excel press Alt+F11, then in VB editor paste code into particular sheet code (choose Sheet on list on left side of editor, dbl click and paste into main window).

Microsoft Excel - Adding 4% To Existing Price Column

LinkBack

Thread Tools

Rate This Thread

Display

Microsoft Excel - Adding 4% To Existing Price Column

Re: Microsoft Excel - Adding 4% To Existing Price Column

Re: Microsoft Excel - Adding 4% To Existing Price Column

Re: Microsoft Excel - Adding 4% To Existing Price Column

Re: Microsoft Excel - Adding 4% To Existing Price Column

Re: Microsoft Excel - Adding 4% To Existing Price Column

Re: Microsoft Excel - Adding 4% To Existing Price Column

Re: Microsoft Excel - Adding 4% To Existing Price Column

Thread Information

Users Browsing this Thread

Similar Threads

Adding new column to the existing VBA code

[SOLVED] Anyone good with Microsoft excel? I need to add to an existing pull down list

Microsoft Excel 2007 Problem Can't add new Excel sheet in the existing file

Help w/ adding information to an existing column

[SOLVED] adding extra text into an existing column

adding extra text into an existing column

adding extra text into an existing column

Bookmarks

Bookmarks

Posting Permissions