| 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 (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! |
| 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 | |||
Threaded Mode
