Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MONTH INCREMENT FORMULA | Excel Discussion (Misc queries) | |||
Increment formula for time | Excel Discussion (Misc queries) | |||
Excel formula to increment the month by 2? | New Users to Excel | |||
Excel formula to increment the month by 2? | Excel Worksheet Functions | |||
How do I increment a formula? | Excel Worksheet Functions |