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.
Hi Christina:
In A4 enter:
=INDIRECT(quot;Equot; amp; COLUMN())*3%
and copy across
--
Gary's Studentquot;Christinaquot; wrote:
gt; Sorry, basic question, searched for answer but couldn't find quickly.
gt;
gt; A B C D E
gt; 1 10
gt; 2 20
gt; 3 30
gt; 4 =E1*3%
gt;
gt; How do I copy the formula in A4 across so that the next one is E2*3%?
gt; Thanks in advance.
Another way:
=INDEX($E:$E,COLUMNS($A:A))*3%
--
Regards,
RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------quot;Gary''s Studentquot; gt; wrote in message
...
Hi Christina:
In A4 enter:
=INDIRECT(quot;Equot; amp; COLUMN())*3%
and copy across
--
Gary's Studentquot;Christinaquot; wrote:
gt; Sorry, basic question, searched for answer but couldn't find quickly.
gt;
gt; A B C D E
gt; 1 10
gt; 2 20
gt; 3 30
gt; 4 =E1*3%
gt;
gt; How do I copy the formula in A4 across so that the next one is E2*3%?
gt; Thanks in advance.
留言列表
