Find & Replace woes

[SlipperyPete]

Hi all,

I have three sheets, with the third sheet adding the values from the first two to provide data of either 0, 1, or 2. I want to replace all 2's on the summation sheet with zero's, but if I do a 'find & replace' it won't let me replace by value, only search by equation which, as you can imagine, wreaks some havoc on everything.
Suggestions?

Here's a sample of what I have

Sheet 1:
1 0
0 1

Sheet 2:
0 0
1 1

Sheet 3:
1 0
1 2

I want all 2's to appear as 0's, but find & replace won't allow this without messing up every two in the selected range, including 2's embedded as part of formulas.

Thanks!

[renegan]

Try replace your formulas on Sheet 3 with this:

Sheet3!B2=if(Sheet2!B2+Sheet1!B2=2,0,Sheet2!B2+Sheet1!B2)

[SlipperyPete]

Yes!

Awesome -- I'm going home