increment an index in a formula
 

I have on A1 0.2, in B1 1 and in C1 sin(3*$a$1*b1). I would like to copy the
formula in c2, c3 ..c100 such that it would do C2 sin(3*$a$1*b1*2)
C3
sin(3*$a$1*b1*3)
C4
sin(3*$a$1*b1*4)
and so forth. How do I do this?

Thanks

increment an index in a formula
 

On Thu, 3 Jan 2008 17:00:03 -0800, otomo
wrote:

I have on A1 0.2, in B1 1 and in C1 sin(3*$a$1*b1). I would like to copy the
formula in c2, c3 ..c100 such that it would do C2 sin(3*$a$1*b1*2)
C3
sin(3*$a$1*b1*3)
C4
sin(3*$a$1*b1*4)
and so forth. How do I do this?

Thanks

C1: =SIN(3*$A$1*$B$1*ROWS($1:1))

Then Fill Down. The Rows argument will increment.
--ron

increment an index in a formula
 

Enter this in C2:

=SIN(3*$A$1*B$1*ROWS($1:2))

And copy down as needed.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"otomo" wrote in message
...
I have on A1 0.2, in B1 1 and in C1 sin(3*$a$1*b1). I would like to copy
the
formula in c2, c3 ..c100 such that it would do C2 sin(3*$a$1*b1*2)
C3
sin(3*$a$1*b1*3)
C4
sin(3*$a$1*b1*4)
and so forth. How do I do this?

Thanks