Hi

Would anyone well ne able to help me with the following problem?

I've got a worksheet in which every cell contains a formula based on cells in other worksheets.

For example: =AVERAGE('Team 1 Q1'!AG24:BI24) .

There are hundreds of other cells in the worksheet that have similar formulas to this.

I would like to change this formula and every other formula in the worksheet to:
=IF(ISERROR(AVERAGE('Team 1 Q1'!AG24:BI24)),"",(AVERAGE('Team 1 Q1'!AG24:BI24)))

or, to whatever the equivalent may be eg.

=AVERAGE('Team 1 Q1'!B167:AF167) would become:

=IF(ISERROR(AVERAGE('Team 1 Q1'!B167:AF167)),"",(AVERAGE('Team 1 Q1'!B167:AF167)))

The cells are not in any 'order' so I can't just change one formula and then drag down to change the ones below it. Is their some sort of really advanced Find and Replace I can use?

Thanks once again for your help.

Cheers

Trevor