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!


--
SlipperyPete
------------------------------------------------------------------------
SlipperyPete's Profile: http://www.excelforum.com/member.php...o&userid=31220
View this thread: http://www.excelforum.com/showthread...hreadid=528726

Try replace your formulas on Sheet 3 with this:

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


--
renegan
------------------------------------------------------------------------
renegan's Profile: http://www.excelforum.com/member.php...o&userid=10450
View this thread: http://www.excelforum.com/showthread...hreadid=528726

Yes!

Awesome -- I'm going home :)


--
SlipperyPete
------------------------------------------------------------------------
SlipperyPete's Profile: http://www.excelforum.com/member.php...o&userid=31220
View this thread: http://www.excelforum.com/showthread...hreadid=528726