View Single Post
  #2   Report Post  
Zbigniew Lewandowski
 
Posts: n/a
Default Incremental formula problem

I have the folowing formula:

IF(ISBLANK(P31),"0",O30+1)

I need to copy this formula down a column, but add 1 to the ned of formula
each row.. O30+2 .. O30+3.. etc.

Any help?
TIA


Hi
use example:
IF(ISBLANK(P31),"0",O30+ROW(A1))
Regards
Zbych