View Single Post
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

One way, assume you want to add 17% to a rnage of cells, best might be to use
a help column and this formula

=A1*(1+17%)


copy down/across
that way you have an audit trail

otherwise put this formula in a cell

=1+17%

or just 117

copy the cell, select the range of cells, do editpaste special and check
multiply,
if you use the =1+17% you probably need to reformat the cells into either
currency or general


Regards,

Peo Sjoblom


"woody" wrote:

How do i increase multiple cells by using a percent formula?