Sleeper: Increment Lines in a formula

[Ricardo Rosa]

Hello,

it?s possible to increment lines automaticaly ? I want to make the formula 1 pass to formula 2, making the array of formula 1 to the right....

formula 1: A1+B1=5
formula 2: A2+B2=5

Please help me !!!!

[Jacob Hilderbrand]

You can put this in a cell:


=A1+B1=5

To return TRUE or FALSE. Then select the cell and put the mouse to the lower right hand corner of the cell. Left click and hold the button and drag the formulas down. The formula will be filled into the cells that you drag over, and the row numbers will be incremented by 1 each time.

[Ricardo Rosa]

HI,

DRJ, the problem is that i don?t want to make the array down... i want to array the formula to the right...

In the atachement you can see in cell K2 this formula:


IF($J2="";"";IF(AND($J2>E$2;$I2<=G$2);H$2;""))

In cell L2, i want to change the formula to this:


IF($J2="";"";IF(AND($J2>$E$3;$I2<=$G$3);$H$3;"")),

I have done this to several cells (M2, n2, o2,...) but i want to make this automaticaly.

I hope you can open the fine now

Best regards

[Bo Duck]

=IF($J2="","",IF(AND($J2>INDIRECT("E"&COLUMN(C1)),$I2<=INDIRECT("G"&COLUMN(C1))),INDIRECT("H"&COLUMN(C1)),""))
Should do the trick.
Put that in L2, fill down, fill across.
Uses the 'COLUMN' function to act as a counter when you fill across.