Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
Incremental formula problem
Thank you. How does it work?
"Zbigniew Lewandowski" wrote: 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 |
#4
|
|||
|
|||
Incremental formula problem
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 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 |
#5
|
|||
|
|||
Incremental formula problem
Thanks again.
"Zbigniew Lewandowski" wrote: 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 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with formula in Excel | Excel Worksheet Functions | |||
Problem with formula | Excel Worksheet Functions | |||
problem with Array Formula | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |