Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
=$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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Search Function that returns an integer not #VALUE! | Excel Worksheet Functions | |||
how do I put in the IF function only integer as true values? | Excel Worksheet Functions | |||
What function to determine the second small integer from a list? | Excel Discussion (Misc queries) | |||
fill cells with even increment rows from a different worksheet | Excel Discussion (Misc queries) | |||
How do I increment a fill series by a number other than 1? Say I. | Excel Worksheet Functions |