To add 7% to all prices..........

enter 1.07 in an unused cell. Copy then select your price list.

EditPaste Special(in place)MultiplyOKEsc.

Clear the cell with 1.07


Gord Dibben MS Excel MVP


On Fri, 5 Jan 2007 14:21:00 -0800, walr wrote:

I have an extensive price list with my buy prices. I need to add a plus 7%
margin to the final purchase figure. Could someone give me an answer please.