View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
otomo otomo is offline
external usenet poster
 
Posts: 1
Default 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