=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