How to write a formula that adds a value in previous cell and gives value for the next cel

[Meeraan]

Hi fellows !

I need these values in a column. Top most cell is -3.1, then -3.01, -3.001, -3.0001 , -3.00001 and so on
Pl. someone suggest how to do this using a formula.

Part (b), assuming these as x values i also need corresponding (function) y values using formula
y= (x^2-9)/(x+3)

Thanks in advance

[:) Sixthsense :)]

May be this..

In A1 Cell

Please Login or Register  to view this content.

In B1 Cell

Please Login or Register  to view this content.

Drag both the formula's to right..

[Ace_XL]

In A1
=ROUNDUP(-3.00000000000001,ROW(A1)+1)
Copy down

In B1
=(A1^2-9)/(A1+3)
Copy down