Insert same If condition into many formulas

[bofonomo]

Hi,

I've done a spreadsheet which has 35 by 88 cells of formulas and calculation, and I want to put for example:

=if(c2="no",0, calculation)

round every fomula, is there an easy way to do this? I really don't want to have to go through every formula and do this.

Possible use find and replace with wild cards?

Any help would be ace.

ta

 

[anandvarma]

use relative references

 

[bofonomo]

how does that work. I'll just google now.

 

[bofonomo]

Each column is difference formula, so that still means changing 88 formulas and then filling down. I need another method, unless I've misunderstood what you mean by that.