Formula
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.
|