In B1 enter 16.53509
In B2 enter =B2-(16.53509-5)/20 and copy down.

In A1 thru B20 we see:

10 16.53509
11 15.9583355
12 15.381581
13 14.8048265
14 14.228072
15 13.6513175
16 13.074563
17 12.4978085
18 11.921054
19 11.3442995
20 10.767545
21 10.1907905
22 9.614036
23 9.0372815
24 8.460527
25 7.8837725
26 7.307018
27 6.7302635
28 6.153509
29 5.5767545
30 5

--
Gary''s Student - gsnu2007g


" wrote:

Hi,

I am trying to create a formula that I can use that will mimic using
the Edit - Fill - Series - Trend & Growth values.

Is there a way to do this? Basically, I know my starting X is 10 and
my starting Y is 16.53509 and my ending X is 30 and my ending Y is 5,
I would like Y values for 11-29.

So in column A I have my X's (10-30) and in column B I have my Y's
(16.53509 {blanks] 5).

Any help is appreciated!

Thanks!