Replicate multiple if statements through a column

notanitgod 

In cell D3 the formula returns a circular reference but you can enter the formula for example in cell C3:

=IF(AND($J$3<(D3/2),(D3/2)<$K$3),$L$3*2,

IF(AND($J$4<(D3/2),(D3/2)<$K$4),$L$4*2,

IF(AND($J$5<(D3/2),(D3/2)<$K$5),$L$5*2,

IF(AND($J$6<(D3/2),(D3/2)<$K$6),$L$6*2,

IF(AND($J$7<(D3/2),(D3/2)<$K$7),$L$7*2,

IF(AND($J$8<(D3/2),(D3/2)<$K$8),$L$8*2,

IF(AND($J$9<(D3/2),(D3/2)<$K$9),$L$9*2,

IF(AND($J$10<(D3/2),(D3/2)<$K$10),$L$10*2,

IF(AND($J$11<(D3/2),(D3/2)<$K$11),$L$11*2,

IF(AND($J$12<(D3/2),(D3/2)<$K$12),$L$12*2,

IF(AND($J$13<(D3/2),(D3/2)<$K$13),$L$13*2,

IF(AND($J$14<(D3/2),(D3/2)<$K$14),$L$14*2,

IF(AND($J$15<(D3/2),(D3/2)<$K$15),$L$15*2,

IF(AND($J$16<(D3/2),(D3/2)<$K$16),$L$16*2,

IF(AND($J$17<(D3/2),(D3/2)<$K$17),$L$17*2,

IF(AND($J$18<(D3/2),(D3/2)<$K$18),$L$18*2,0))))))))))))))))

When you fill the formula down this is returned in cell C9:

=IF(AND($J$3<(D9/2),(D9/2)<$K$3),$L$3*2,

IF(AND($J$4<(D9/2),(D9/2)<$K$4),$L$4*2,

IF(AND($J$5<(D9/2),(D9/2)<$K$5),$L$5*2,

IF(AND($J$6<(D9/2),(D9/2)<$K$6),$L$6*2,

IF(AND($J$7<(D9/2),(D9/2)<$K$7),$L$7*2,

IF(AND($J$8<(D9/2),(D9/2)<$K$8),$L$8*2,

IF(AND($J$9<(D9/2),(D9/2)<$K$9),$L$9*2,

IF(AND($J$10<(D9/2),(D9/2)<$K$10),$L$10*2,

IF(AND($J$11<(D9/2),(D9/2)<$K$11),$L$11*2,

IF(AND($J$12<(D9/2),(D9/2)<$K$12),$L$12*2,

IF(AND($J$13<(D9/2),(D9/2)<$K$13),$L$13*2,

IF(AND($J$14<(D9/2),(D9/2)<$K$14),$L$14*2,

IF(AND($J$15<(D9/2),(D9/2)<$K$15),$L$15*2,

IF(AND($J$16<(D9/2),(D9/2)<$K$16),$L$16*2,

IF(AND($J$17<(D9/2),(D9/2)<$K$17),$L$17*2,

IF(AND($J$18<(D9/2),(D9/2)<$K$18),$L$18*2,0))))))))))))))))