question about excel formulae

[Ted Walls]

How can I make excel do this over rows:

A1 = x
A2 = x * 1.03
A3 = A2 * 1.03
....
....



Submitted via EggHeadCafe - Software Developer Portal of Choice
ASP.NET Session State FAQs
http://www.eggheadcafe.com/tutorial...b3-6663b41660b9/aspnet-session-state-faq.aspx

 

[Joe User]

How can I make excel do this over rows:
A1 = x
A2 = x * 1.03
A3 = A2 * 1.03
...

Well, you almost have it yourself.

A1: 123
A2: =A1*1.03

Copy A2 to A3 and other cells. You will see that Excel automagically change
A1 to the previous cell name.