replace value in excel?
 

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 &
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.

replace value in excel?
 

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: http://www.excelforum.com/member.php...o&userid=19838
View this thread: http://www.excelforum.com/showthread...hreadid=498969

replace value in excel?
 

I 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

wrote in message
ups.com...
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 &
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.

replace value in excel?
 

On 6 Jan 2006 16:29:11 -0800, wrote:

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 &
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.

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