Copy Formula

C

carl

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
 
C

carl

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.
 
E

excelent

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


"carl" skrev:
 

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

Top