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.

Either create an extra column and use

=A2*1.07

where A2 holds the value that you want to add the 7% to, copy down as
long as needed

or put 1.07 in an empty cell formatted as currency, then copy it, select
all values and do editpaste special and select multiply


Regards,

Peo Sjoblom

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.

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.