Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,572
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
MONTH INCREMENT FORMULA deepak bsg[_2_] Excel Discussion (Misc queries) 3 August 23rd 07 08:56 AM
Increment formula for time Ltat42a Excel Discussion (Misc queries) 4 August 2nd 06 11:21 PM
Excel formula to increment the month by 2? thirumalairajan New Users to Excel 5 February 12th 06 12:20 AM
Excel formula to increment the month by 2? thirumalairajan Excel Worksheet Functions 2 February 10th 06 09:23 AM
How do I increment a formula? JICDB Excel Worksheet Functions 2 September 16th 05 06:53 PM


All times are GMT +1. The time now is 12:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"