Formula to fill series

[bhandari]

A1=start from 10.000
A2=end from 150.000



IF C1=10
D2=10,D2=20,D3=30....UP to 150 values should appear in D column
iF C1=20
gap should be 20
D2=20,D3=40....up to 150 values sjould appear in D column

 

[Joe4]

Re: i need help with dragging

Try entering this formula in D1 and copy down:

=MIN($A$1+($C$1*(ROW()-1)),$A$2)

 

[bhandari]

Re: i need help with dragging

Try entering this formula in D1 and copy down:

=MIN($A$1+($C$1*(ROW()-1)),$A$2)

awsome it works fine.