Copy Formula
 

I have this formula:

=IF(ISNUMBER(C6/B6);(C6/B6);0)

Is there a way to copy the formula in each cell in the row so that the
division will work like this:

next cell in row (E6/D6)
next cell in row (G6/F6)

and so on.

Thank you in advance

Copy Formula
 

=INDIRECT(CHAR(COLUMN()*2+63)&6)/INDIRECT(CHAR(COLUMN()*2+62)&6)


"carl" skrev:

I have this formula:

=IF(ISNUMBER(C6/B6);(C6/B6);0)

Is there a way to copy the formula in each cell in the row so that the
division will work like this:

next cell in row (E6/D6)
next cell in row (G6/F6)

and so on.

Thank you in advance

Copy Formula
 

Thank you so much for your help.

I did not copy my original formula correcty in the original post.

My original formula is this:

=IF(ISNUMBER(Sheet4!C6/Sheet4!B6);(Sheet4!C6/Sheet4!B6);0)

What to do ?

Thanks again.

"excelent" wrote:

=INDIRECT(CHAR(COLUMN()*2+63)&6)/INDIRECT(CHAR(COLUMN()*2+62)&6)


"carl" skrev:

I have this formula:

=IF(ISNUMBER(C6/B6);(C6/B6);0)

Is there a way to copy the formula in each cell in the row so that the
division will work like this:

next cell in row (E6/D6)
next cell in row (G6/F6)

and so on.

Thank you in advance

Copy Formula
 

try
=OFFSET(Sheet4!$A$6,0,COLUMN()*2-2)/OFFSET(Sheet4!$A$6,0,COLUMN()*2-3)


"carl" skrev:

Thank you so much for your help.

I did not copy my original formula correcty in the original post.

My original formula is this:

=IF(ISNUMBER(Sheet4!C6/Sheet4!B6);(Sheet4!C6/Sheet4!B6);0)

What to do ?

Thanks again.

"excelent" wrote:

=INDIRECT(CHAR(COLUMN()*2+63)&6)/INDIRECT(CHAR(COLUMN()*2+62)&6)


"carl" skrev:

I have this formula:

=IF(ISNUMBER(C6/B6);(C6/B6);0)

Is there a way to copy the formula in each cell in the row so that the
division will work like this:

next cell in row (E6/D6)
next cell in row (G6/F6)

and so on.

Thank you in advance