Thread
:
replace value in excel?
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld
Posts: n/a
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
Reply With Quote