VB using if statement

[Casey]

Hello,
I was wondering if anyone knows how to use an if statement in this context. If a cell has a numerical value then perform such and such operation i.e. if cell is a number then divide by two and put in another cell, otherwise do nothing.
thanks for any advice you could give
Casey

[Mark O'Brien]

Suppose Cell "A1" on "Sheet1" holds the value, suppose cell "B1" on the same sheet is to hold the result, you would use the "if" statement like this:

  With Sheets("Sheet1")

    If IsNumeric(.Range("A1").Value) Then

      .Range("B1").Value = .Range("A1").Value / 2

    End If

  End With

HTH

_________________
[b] Mark O'Brien

[ This Message was edited by: Mark O'Brien on 2002-05-10 11:35 ]

[Casey]

Thankyou very much I didnt know there is a Isnumeric function.
thanks again
Casey