| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Function to automatically fill in an array of cells
Hello,
Is it possible to construct a function for the following problem: Im looking for a method in Excel to automatically fill in a range of cells (column A), given a value for the step and an end value. Example: If InitialValue (A1) = 0.5 Step = 0.1 EndValue = 1 Then column A should go from 0.5 (in cell A1) to 1 (in cell A6) in steps of 0.1. If I adjust the step to 0.05, column A should automatically become 2 times longer. Can somebody help me with this? Thanks, Maarten |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to have cells automatically fill when entering value in ref | Excel Discussion (Misc queries) | |||
| how to have cells automatically fill when entering value in ref | Excel Discussion (Misc queries) | |||
| Fill in cells with an array | Excel Discussion (Misc queries) | |||
| Help using the 'If' function to automatically fill in other cells | Excel Worksheet Functions | |||
| need to fill cells automatically | Excel Worksheet Functions | |||
Threaded Mode
