software

Hi,

Is there a replace function that can be used within IF function on
excel worksheet?
In one column A, I have two same number underneath each other...like

1755 - A1
1755 - A2

On the other column B, I have two different values...like

17500 - b1
25000 - b2

Now, what I want to do is insert a column C, and want to compare amp;
replace: =if(a1=a2, replace b2 to b1....means I want b1 to replace by
value of b2.

Can someone help me with that?

Thank you in advance for your help.
Unfortunately the worksheet functions cannot alter the values of a cell
outside of the one with the formula. For example a formula in A1 can
only change cell A1. To do that you would need you would have to use
code in the VBA. Perhaps if you re-posted your problem in the
Programing section someone could give you some help.

Sorry I couldn't be more helpful.--
goober
------------------------------------------------------------------------
goober's Profile: www.excelforum.com/member.php...oamp;userid=19838
View this thread: www.excelforum.com/showthread...hreadid=498969I am not sure that I understand exactly what it is that you are asking.
Does:

=IF(A1=A2,B1,B2) wntered in column C do what you want?
--
HTH

Sandy
with @tiscali.co.uk

gt; wrote in message ups.com...
gt; Hi,
gt;
gt; Is there a replace function that can be used within IF function on
gt; excel worksheet?
gt; In one column A, I have two same number underneath each other...like
gt;
gt; 1755 - A1
gt; 1755 - A2
gt;
gt; On the other column B, I have two different values...like
gt;
gt; 17500 - b1
gt; 25000 - b2
gt;
gt; Now, what I want to do is insert a column C, and want to compare amp;
gt; replace: =if(a1=a2, replace b2 to b1....means I want b1 to replace by
gt; value of b2.
gt;
gt; Can someone help me with that?
gt;
gt; Thank you in advance for your help.
gt;
On 6 Jan 2006 16:29:11 -0800, wrote:

gt;Hi,
gt;
gt;Is there a replace function that can be used within IF function on
gt;excel worksheet?
gt;In one column A, I have two same number underneath each other...like
gt;
gt;1755 - A1
gt;1755 - A2
gt;
gt;On the other column B, I have two different values...like
gt;
gt;17500 - b1
gt;25000 - b2
gt;
gt;Now, what I want to do is insert a column C, and want to compare amp;
gt;replace: =if(a1=a2, replace b2 to b1....means I want b1 to replace by
gt;value of b2.
gt;
gt;Can someone help me with that?
gt;
gt;Thank you in advance for your help.

The only way you can change B1 using a worksheet function is with a formula in
b1. For example:

B1:=if(a1=a2,b2,17500)

You could replace the 17500 with a formula or cell reference. So let's say you
entered the 17500 in D1, then:

B1:=if(a1=a2, b2, d1)

A VBA macro could also effect the change, if you want to go that route.--ron