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?