Copying vertical references horizontally

C

Christina

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.
 
G

Gary''s Student

Hi Christina:

In A4 enter:
=INDIRECT("E" & COLUMN())*3%
and copy across
 
R

RagDyeR

Another way:

=INDEX($E:$E,COLUMNS($A:A))*3%

--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------


Hi Christina:

In A4 enter:
=INDIRECT("E" & COLUMN())*3%
and copy across
 
Top