| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cannot Expand Named Range - when size of the Range exceeds | Excel Discussion (Misc queries) | |||
| How to dynamically reference a dynamic named range | Excel Worksheet Functions | |||
| How can I apply the ROUND function to a range of cells in a workbo | Excel Discussion (Misc queries) | |||
| How do I apply the ROUNDUP formula to a range of calculated data | Excel Worksheet Functions | |||
| Define a range based on another named range | Excel Worksheet Functions | |||
Linear Mode
