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?