Incremental formula problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...

Hi
use example:
IF(ISBLANK(P31),"0",O30+ROW(A1))
Regards
Zbych
 
Thank you. How does it work?
function ROW(A1) return number of row in address A1,
if you copy this formula down a column, exist row(a1), row(a2), row(a3),
etc.
this function return 1, 2, 3, etc.
Regards
Zbych
 
Thanks again.

Zbigniew Lewandowski said:
function ROW(A1) return number of row in address A1,
if you copy this formula down a column, exist row(a1), row(a2), row(a3),
etc.
this function return 1, 2, 3, etc.
Regards
Zbych
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to avoid #DIV/0, I AM USING =AVERAGE(IF(F30:F69=3,O30:O69,"0") 5
Sort Function with a Twist 1
My & and TEXT formula is not calculating 2
Adding columns with dates - 2
Copying Formulas Between Worksheets 2
Adding columns with dates 1
if it looks like it matches, it's a match 1
Copying Lookup formulas 2

Back
Top