compare values

[M]

I have 2 columns
first column Second column
c 887
d 9876
d 9776
c 7565
d 9765
want to write a function to check in the first column whether C is there if
C is present then the corresponding value in the second column should become
-887.

if found

c -887
Please let me know.
Thanks
M

 

[Andy Brown]

if found

c -887

You could try a macro ; with the first column cells selected, something like

Sub C_Minus()
For Each Cell In Selection
If UCase(Cell) = "C" Then
Cell.Offset(0, 1) = Cell.Offset(0, 1) - (Cell.Offset(0, 1) * 2)
End If
Next Cell
End Sub

HTH,
Andy