asked on

Change Price list by fixed percentage in Excel

Hi Experts,

I'm trying to update my price list in Excel and add 2.5% to each value in the price list. The price list contains 3 sheets and has some fields that are just text, which should be ignored. I have attached the price list.

Please help! -2011-.xls

Muhammad Ahmad Imran

Here is the help

Let's say you have a list of values in A1:A100 and you need to increase these values all by 15%.

1. Enter the number 1.15 into any blank cell and then Copy it
2. Now select the range A1:A100 and go to Edit>Paste Special
3. Choose Values from under Paste and then Multiply under Operation and click OK.

All value will now have increased by 15%

oxi1

ASKER

I have tried this but nothing happens when I do it. Could it be that Excel 2011 for Mac operates differently?

ASKER CERTIFIED SOLUTION

TheAvenger

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

oxi1

ASKER

@TheAvenger: Thanks for your solution. I'm having trouble following your steps:
I have created the formula in I1
- Copying H1 would copy "Price" and paste it all down H?

Sorry if I'm not getting what you meant, but could you please elaborate?

Thanks a lot.

TheAvenger

Just select I1 (sorry, it's I1, not H1) this was a typo, select H2-H35 and paste. This will copy the formula down

oxi1

ASKER

Great way to solve this, thanks a lot!