Changing a common value in multiple formulas

[clintclarskon]

This might be an obvious question but I can't seem to locate a solution.

I have the following formula:

=IF(($S6=180),1,0)

It is repeated down the column:

=IF(($S7=180),1,0)
=IF(($S8=180),1,0)
=IF(($S9=180),1,0)

What I would like to be able to do is change the column "S" to another value in all of the formulas without doing them 1 by 1. Is there a way to select all of the formulas and change the common column value?

Cheers,


Clint C.

 

[sbeatton]

Use Find and Replace. Cntrl + F Find $S Replace with $X where X is your letter

 

[clintclarskon]

I knew there was an easy fix... thanks very much! It worked perfect.