replace value in excel?

S

sndesai74

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

goober

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

Ron Rosenfeld

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.
Click to expand...

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
 
Top