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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Many thanks Duke for your help.

Duke Carey said:
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
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional formatting on a dynamic range - workaround 1
Help With MS Access 4
How do I invoice a cost to a custom built MS Access Accounting Database? 0
How to applying a ratio (whilst keeping total the same!) 2
Cell referencing 1
Set non-continuous PrintArea via Function / Name 0
how do I figure multiple commission percentages 1
Creating a formula to increase a figure by a percentage. 0

Back
Top