Trying to add tiered pricing to a CSV

Hi all,

Really scratching my head at this, im not a very advanced Excel user to please excuse my likely poor and confusing issue!

Im trying to add tiered pricing to an export of about 3000 products from a website, for example item A is £10, for 2 x item A its 5% off, for 5 x item A its 10% off ect.

The format i need to use is on multiple rows, i have found and run a Macro to enter all blank rows that i need, i now just need to populate the fields.

The problem im having is that i cant find a way to run a simple formula (remove a certain %) for each product at the same time, i can only do 1 product then copy / paste and charge the formula to see the new price field

My spreadsheet currently looks like: current.xlsx

I need it to be populated with a set % for each product, like this: required.xlsx

Any help is really appreciated on this, at a complete loss.

Cheers

Steve

Hi Richard, thanks for the rapid reply!

Can i quickly copy the formula it works for all 3000 SKU's?

Thanks
Steve

Hi Richard,

The price of every SKU is different (each SKU price is in the price column) however the rate of discount % will remain the same for each SKU

Hi Humdingaling,

Sorry for the confusion, in my example the rates of discount i was using were different (i think 5/8/12/15%) its just different while i was playing around with a few things, i dont yet have the final % that needs to be used so hoping this can be changed easily at a later date

Thanks

Steve

Thanks both, both solutions work perfectly!