Adding to a formula thru out a worksheet

E

Eden397

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?
 
P

Pete_UK

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
 
E

Eden397

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Validation - Complex Q 2
Help with formula 3
Count Ranges Q 2
How do I clear a form? 0
Formula query? 6
Need Formula Help 0
Need formula Help soon 4
Averaging Array Formula 5

Top