Adding to a formula thru out a worksheet
 

Hi, I currently have the following formula in every 5th row for a total of
4500 rows.

=IF(ISERR((P59/'Data Entry'!J10)*'Data Entry'!K10)=TRUE,0,(P59/'Data
Entry'!J10)*'Data Entry'!K10)

I want to add the following to the begining of all these formula's:
=IF(H59=0, and the condition " ,1)" at the end

so my new formula would be:

=IF(H59=0,IF(ISERR((P59/'Data Entry'!J10)*'Data
Entry'!K10)=TRUE,0,(P59/'Data Entry'!J10)*'Data Entry'!K10),1)

Is there a systematic way of doing this rather than manually?

Adding to a formula thru out a worksheet
 

Are the cells between the formulas empty? And does the formula in the
5th cell follow on as if copy/pasted from the 1st cell?

If the answer to both questions is yes, then you could apply
autofilter to the column and select Non-blanks. Then in the uppermost
visible cell you could make the amendment once, and then <copy that
cell and paste over just the visible cells (the ones with the current
formula in). Then choose All from the filter pull-down.

Hope this helps.

Pete


On Jul 30, 6:13*pm, Eden397 wrote:
Hi, I currently have the following formula in every 5th row for a total of
4500 rows.

=IF(ISERR((P59/'Data Entry'!J10)*'Data Entry'!K10)=TRUE,0,(P59/'Data
Entry'!J10)*'Data Entry'!K10)

I want to add the following to the begining of all these formula's: *
=IF(H59=0, and the condition " ,1)" *at the end

so my new formula would be:

=IF(H59=0,IF(ISERR((P59/'Data Entry'!J10)*'Data
Entry'!K10)=TRUE,0,(P59/'Data Entry'!J10)*'Data Entry'!K10),1)

Is there a systematic way of doing this rather than manually?

Adding to a formula thru out a worksheet
 

No and No. J10 and K10 will move to J11 and K11 and the P59 will go to P60
but, it is pulling data from another worksheet where the rows are consecutive
but it is on a worksheet where I need that consecutive data spaced every 5
rows.

=IF(ISERR((P59/'Data Entry'!J10)*'Data Entry'!K10)=TRUE,0,(P59/'Data
Entry'!J10)*'Data Entry'!K10)
"Pete_UK" wrote:

Are the cells between the formulas empty? And does the formula in the
5th cell follow on as if copy/pasted from the 1st cell?

If the answer to both questions is yes, then you could apply
autofilter to the column and select Non-blanks. Then in the uppermost
visible cell you could make the amendment once, and then <copy that
cell and paste over just the visible cells (the ones with the current
formula in). Then choose All from the filter pull-down.

Hope this helps.

Pete


On Jul 30, 6:13 pm, Eden397 wrote:
Hi, I currently have the following formula in every 5th row for a total of
4500 rows.

=IF(ISERR((P59/'Data Entry'!J10)*'Data Entry'!K10)=TRUE,0,(P59/'Data
Entry'!J10)*'Data Entry'!K10)

I want to add the following to the begining of all these formula's:
=IF(H59=0, and the condition " ,1)" at the end

so my new formula would be:

=IF(H59=0,IF(ISERR((P59/'Data Entry'!J10)*'Data
Entry'!K10)=TRUE,0,(P59/'Data Entry'!J10)*'Data Entry'!K10),1)

Is there a systematic way of doing this rather than manually?