Faster way to edit formulas?

[81shelly]

Hi

Just wondering if ther is a quick way to change a number of the same cell references in one go? for exampe in this formula below i want to change the $C$5 to another one like $F$5 but the way I'm doing it at the moment is to type it in 8 times... Anyone know if could change all 8 instances of it in one go?

=IF(Sheet2!E7=$C$5,2,IF(Sheet2!E7=$C$5+1,1,IF(Sheet2!E7=$C$5-1,3,IF(Sheet2!E7=$C$5-2,4,IF(Sheet2!E7=$C$5-3,5,IF(Sheet2!E7=$C$5-4,6,IF(Sheet2!E7=$C$5-5,7, IF(Sheet2!E7>$C$5+1,0))))))))

Thanks in advance..

 

[SteveO59L]

Edit, Replace ?

 

[Peter_SSs]

Have a look at Edit|Replace...|Options|Look in: Formulas