Remember Me?

#1
Posted to microsoft.public.excel.worksheet.functions
 external usenet poster Posts: 3
increment an integer in a formula with the fill function

Hi--
there must be a way to do this that I am missing. I want to fill a column
with incremental multiples (2-36) of a constant cell. If I type
\$A\$1*2
\$A\$1*3
and then try to fill the series, it doesn't work. Cell A1 represents a
dollar amount, I want to see that amount multiplied by # of months for 36
months in a column. Why can't I get the integer to increment by filling the
series? How should I do this??? Thanks!
#2
Posted to microsoft.public.excel.worksheet.functions
 external usenet poster Posts: 10,593
increment an integer in a formula with the fill function

=\$A\$1*ROW(A2)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"vexed" wrote in message
...
Hi--
there must be a way to do this that I am missing. I want to fill a column
with incremental multiples (2-36) of a constant cell. If I type
\$A\$1*2
\$A\$1*3
and then try to fill the series, it doesn't work. Cell A1 represents a
dollar amount, I want to see that amount multiplied by # of months for 36
months in a column. Why can't I get the integer to increment by filling
the
series? How should I do this??? Thanks!

#3
Posted to microsoft.public.excel.worksheet.functions
 external usenet poster Posts: 3,440
increment an integer in a formula with the fill function

use =\$A\$1*ROW()

depending on what the first row is, you may have to subtract 1 or 2 from ROW()

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"vexed" wrote in message ...
| Hi--
| there must be a way to do this that I am missing. I want to fill a column
| with incremental multiples (2-36) of a constant cell. If I type
| \$A\$1*2
| \$A\$1*3
| and then try to fill the series, it doesn't work. Cell A1 represents a
| dollar amount, I want to see that amount multiplied by # of months for 36
| months in a column. Why can't I get the integer to increment by filling the
| series? How should I do this??? Thanks!

#4
Posted to microsoft.public.excel.worksheet.functions
 external usenet poster Posts: 3
increment an integer in a formula with the fill function

Thank you!!!! Not intuitive at all, but at least now I know!

"Bob Phillips" wrote:

=\$A\$1*ROW(A2)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"vexed" wrote in message
...
Hi--
there must be a way to do this that I am missing. I want to fill a column
with incremental multiples (2-36) of a constant cell. If I type
\$A\$1*2
\$A\$1*3
and then try to fill the series, it doesn't work. Cell A1 represents a
dollar amount, I want to see that amount multiplied by # of months for 36
months in a column. Why can't I get the integer to increment by filling
the
series? How should I do this??? Thanks!

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post DavidH Excel Worksheet Functions 2 March 28th 07 04:26 PM suat Excel Worksheet Functions 1 November 3rd 06 06:17 PM Eric Excel Discussion (Misc queries) 1 December 30th 05 02:05 PM FormulaChallenged Excel Discussion (Misc queries) 4 December 7th 05 08:39 PM John Excel Worksheet Functions 3 January 6th 05 09:34 PM

All times are GMT +1. The time now is 08:43 PM.