How do I apply a % +/- to a range of figures please
 

I have a range of data which I need to be able to decrease by a certain %
figure, based on what is agreed.

Can someone please help me.

Thanks

in an empty cell enter

=1-n

where n = the decimal amount to decrease, i.e., .1 for a 10% decrease

copy the cell

select the range of values to be reduced

use Edit | Paste Special | Multiply



"marseans" wrote:

I have a range of data which I need to be able to decrease by a certain %
figure, based on what is agreed.

Can someone please help me.

Thanks

Many thanks Duke for your help.

"Duke Carey" wrote:

in an empty cell enter

=1-n

where n = the decimal amount to decrease, i.e., .1 for a 10% decrease

copy the cell

select the range of values to be reduced

use Edit | Paste Special | Multiply



"marseans" wrote:

I have a range of data which I need to be able to decrease by a certain %
figure, based on what is agreed.

Can someone please help me.

Thanks