Formula in lopp

[nikeshgoyal]

Hi,

My cells are like that:

=3*1
=3*2
=3*3

Now, I want my next cells should be multiples of 3 in the same order. Now fourth cell should be 12. I tried with scrolling down the formula but it's repeated 3,6,9 again.. It should be 12, 15, 18 and so on..

Please reply how to do it.

[jraj1106]

Hi

I tried this by having nums 1 to 10 in B col. Then use the count in the formula "=3*B1" and then drag it down..

Or do you want a macro for this?

[Cutter]

Use:

=3*ROW(A1) and drag down as far as you want