I can't find this same issue in any of the previous posts, so if it has been asked before, I appologize.

I have a formula to check two cells for values. If the values are above zero, then divid them. If not, return a zero.

=IF(G8=0,0,IF(G9=0,,G8/G9))

(This keeps me from getting a #DIV/0 result)

The problem is when I try to auto fill this formula down.

=IF(G8=0,0,IF(G9=0,,G8/G9))
=IF(G10=0,0,IF(G11=0,,G10/G11))
=IF(G12=0,0,IF(G13=0,,G12/G13))

Above, is how I need it to fill, but

=IF(G8=0,0,IF(G9=0,,G8/G9))
=IF(G9=0,0,IF(G10=0,,G9/G10))
=IF(G10=0,0,IF(G11=0,,G10/G11))

this is how it auto fills.

Cells G8 and G9 should be divided, Cells G10 and G11 should be divided, and so on.

I'm sure there has to be an easier way than to type the formula into the 300+ fields, but I can't figure it out.

Any help would be much appreciated.

TD