Thread: Formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default 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.