Hi Christina:

In A4 enter:
=INDIRECT("E" & COLUMN())*3%
and copy across
--
Gary's Student


"Christina" wrote:

Sorry, basic question, searched for answer but couldn't find quickly.

A B C D E
1 10
2 20
3 30
4 =E1*3%

How do I copy the formula in A4 across so that the next one is E2*3%?
Thanks in advance.