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?
|