No, you cannot affect another cell with worksheet formulas. For that you
would need VBA (Visual Basic for Applications).

If you right click your sheet tab and select View Code, then paste this in
there, it may work for you ...


Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)
If Range("N5").Value = "Removed" Then Range("J5").Value = 0
End Sub


HTH

--
Regards,
Zack Barresse, aka firefytr


"Todd Nelson" wrote in message
...
Is there a formula that will change another cells information w/o having a
formula in that particular cell. For instance, the IF(N5=Removed" then
J5=0)
without putting a formula in j5?