Home 
Search 
Today's Posts 
#1
Posted to microsoft.public.excel.worksheet.functions




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 (236) 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




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 (236) 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




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 (236) 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




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 (236) 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  


Similar Threads  
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 