Find & Replace woes

S

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!
 
R

renegan

Try replace your formulas on Sheet 3 with this:

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