Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Fill Problems
I have a formula that I want to implement for a series of data points. For
the first cell(A1) the formula would be "IF(E5=0, NA(), E6/E5)" The next cell in the series (A2) would be "IF(E8=0, NA(), E9/E8)". So each time the formula is iterated it increases each cell value by three. So, continuing the example the next cell (A3) would contain "IF(E11=0, NA(), E12/E11)". However, when I try the click-fill method it iterates by 1. I also cannot have excel do this using the Edit -Fill- Series method either. How may I iterate formulas by values different than 1? excelBRISKbaby |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula problems | Excel Discussion (Misc queries) | |||
Formula problems | Excel Worksheet Functions | |||
Problems with auto-fill of dates | Excel Discussion (Misc queries) | |||
Formula Problems | Excel Worksheet Functions | |||
autoshape fill problems in Excel 2003 | Excel Discussion (Misc queries) |