View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Joe User[_2_] Joe User[_2_] is offline
external usenet poster
 
Posts: 905
Default question about excel formulae

<Ted Walls wrote:
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.