setting cell value to nullwithif statement

[wmtsub]

often I will clear a cells value with an if statement
=if(condition) then, "Action","").
My issue is with the "".
Instead of setting the cell to "" how to I just make it a blank cell?

 

[wmtsub]

I use a formula in one cell to clear a different cell

 

[shg]

A native Excel formula can't do anything except return a value to the cell in which it appears.

A user-defined function called from a cell can do a few other oddities, but can't change the contents of another cell.

 

[wmtsub]

THEN WHY DOES THIS WORK?

Private Sub Worksheet_Change(ByVal Target As Range)
If Range("I11").Value > 0 Then
Range("L11").Value = "ok"
End If
End Sub

 

[Fluff]

That is neither an Excel function, nor a user defined function.
It's a worksheet event.