Number In Formula Doesn't Increase When Dragged To Other Cells

[derv10]

Hi,

I have this formula: =IF(C$9>=1,A14+1,"")


But when I drag the formula down to multiple rows the highlighted number doesn't incrementally increase. Can someone help make this happen?


Thanks!!

[Olly]

Assuming the formula starts in Row 1:

Please Login or Register  to view this content.

[Special-K]

Assuming this is in row 1

=IF(C$9>=ROW(),A14+1,"")

If it's NOT in row one you'll have use a simple addition calculation to get the right result.
e.g.
if it's in Row 2 then you want
=IF(C$9>=ROW()-1,A14+1,"")

if it's in Row 3 then you want
=IF(C$9>=ROW()-2,A14+1,"")

You'll need to experiement with the ROW() number so you get the correct offset you want.
Or you might be able to include the OFFSET and ROW function togethe rot produce the correct row number.

[derv10]

It doesn't seem to be working? I'll try to explain better:

Cell C9 is a duration calculated between 2 dates which I input (A9 is start date and B9 is end date)
Cell A14 is my 'day 1' which is simply =A9 in the cell
Cell A15 is the start of my formula which I want to insert the date if it is within the duration.

So
A15 = =IF(C$9>=1,A14+1,"")
A16 = =IF(C$9>=2,A14+1,"")
A17 = =IF(C$9>=3,A14+1,"")

And so on. When C9 is not greater than or equal to the duration then no date is present. The problem I have is making the greater than or equal to number increase as I drag the formula down each row.


Hope this is clearer?!?! :$

Thanks!

[Olly]

So, in cell A15, enter:

Please Login or Register  to view this content.

You can now drag-copy this formula down...

[derv10]

Thank you!! Works great