Thread: Copy Formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carl Carl is offline
external usenet poster
 
Posts: 361
Default 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