excel vba - if "x" = 0 or less than...then

[chief]

I was wondering what formula would be used for

If Sheet5.Range("K7").Value = "<0" Then
Range("K7").ClearContents

The point is that if this cell value is less than equal to or less
than 0, it will clear itself.

Any idea

 

[Frank Kabel]

Hi
not possible with formulas

 

[DNF Karran]

Less than or equal to is just: <= (or =<)

ie

If Sheet5.Range("K7").Value =< 0 Then
Range("K7").ClearContents

Dunca

 

[chief]

Thanks Buddy

Worked out goo