Copying formula

[Jchab]

Hello excel gurus

Would love your help.

I am trying to copy a formula across cells, but I can't seem to find a way for it do what I want. I don't want to have to manually change 50 formulas across each cell and over 10 worksheets....can anyone help??

The first formula in the cell is =IF($B7>0,$B5,0)
I then want the next one to be =IF($B7>1,$B5, IF($J8=2,$B8,0)) the next one to be =IF($B7>2,$B5, IF(J8=3,B8,0)), and so on
but when I copy it I have to manually change the numbers in (bolded text) =IF($B7>3,$B5, IF(J8=4,B8,0)), =IF($B7>5,$B5, IF(J8=6,B8,0)),

Looking forward to your answers

Cheers

Jade

 

[jolivanes]

If you copy this "=IF($B7>0,$B5,0)", you will not get "=IF($B7>1,$B5, IF($J8=2,$B8,0))"
Also, in your last line you jump by 2 although you seem to want to just increase by one. ($B7>3 and next one is $B7>5)
Let us know what it needs to be.