Drag copying

[ddub25]

Is there a way of drag copying the formula below to the right so that the last cell reference will increment by one each time. The last cell reference is $F$30. When I drag the formula to the right to copy it, I want $F$30 to have changed to $F$31.

=IF(AND($B30<>"",$A30>=M$25),$F30-$F$30,"--")

I have 600 columns and don't really want to have to manually adjust the formula.

Dan

 

[mikerickson]

I think
=IF(AND($B30<>"",$A30>=M$25), $F30 - INDEX($F:$F,COLUMN(AD1),1), "--")

 

[T. Valko]

Is there a way of drag copying the formula below to the right so that the last cell reference will increment by one each time. The last cell reference is $F$30. When I drag the formula to the right to copy it, I want $F$30 to have changed to $F$31.

=IF(AND($B30<>"",$A30>=M$25),$F30-$F$30,"--")

I have 600 columns and don't really want to have to manually adjust the formula.

Dan

Try this...

Let's assume the first cell the formula will be entered in is cell B2.

=IF(AND($B30<>"",$A30>=M$25),$F30-INDEX($F$30:$F$1000,COLUMNS($B2:B2)),"--")

Adjust for the correct end of range F1000.

 

[ddub25]

thanks, that's great - does exactly what I want.

Dan