Change the value of a cell
 

I need a formula that changes the value of one cell based on the value of
another.

If my value in A2 equals DS I want to change the value of cell M2 to match
the value of B2.
Else do not change any values.

T.I.A.

Dayton

Change the value of a cell
 

Dim cell as Range
Set cell = ???? ' Activecell, or Range("C2"), or ???
If Range("A2") = "DS" then
cell = Range("B2")
End If

--
sb
"dayton" wrote in message
...
I need a formula that changes the value of one cell based on the value of
another.

If my value in A2 equals DS I want to change the value of cell M2 to match
the value of B2.
Else do not change any values.

T.I.A.

Dayton

Change the value of a cell
 

formula in cell m2
=if(a2="ds",b2,"")

"dayton" wrote in message
...
I need a formula that changes the value of one cell based on the value of
another.

If my value in A2 equals DS I want to change the value of cell M2 to match
the value of B2.
Else do not change any values.

T.I.A.

Dayton