#### jackdruck

##### New Member
What would be an easy way to obtain a range of values that results from a 20% increase and a 20% decrease in the value contained in cell B2? ( I wrote formulas for 41 cells that would comprise the range, like B2*0.80, B2*0.81 … and so on up to B2*1.20. But there must be a simpler way.)
I would be very grateful for any suggestion.

### Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

#### MickG

##### MrExcel MVP
Hi, This will give you "- 20%" to "+ 20%"
Code:
``````[COLOR=navy]Sub[/COLOR] MG06Dec14
[COLOR=navy]Dim[/COLOR] n [COLOR=navy]As[/COLOR] [COLOR=navy]Integer,[/COLOR] r [COLOR=navy]As[/COLOR] Double, Num [COLOR=navy]As[/COLOR] Double, c [COLOR=navy]As[/COLOR] [COLOR=navy]Integer[/COLOR]
r = 0.01
Num = Range("B2") * (1 - 0.20792079)
[COLOR=navy]For[/COLOR] n = 1 To 42
c = c + 1
Range("B" & n + 2).Value = Num * (1 + r) ^ c
[COLOR=navy]Next[/COLOR] n
[COLOR=navy]End[/COLOR] [COLOR=navy]Sub[/COLOR]``````
Regards Mick

Last edited:

#### jackdruck

##### New Member
Thank you very much Mick.

Regards Jack

Replies
3
Views
39
Replies
1
Views
81
Replies
8
Views
93
Replies
12
Views
128
Replies
1
Views
668

1,128,063
Messages
5,628,379
Members
416,314
Latest member
Dan99321

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back