question about excel formulae

J

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top