How?? If N5=removed, j5=0, is what i need it to state

"Duke Carey" wrote:

No. A cell formula cannot change another cell.

You can write code to react to value changes in cell N5 and the *code* can
change the value in J5


"Todd Nelson" wrote:

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?