Checking if value is a number
 

How would I check to see if a value is an integer? Is there such
function

I am trying to grab values off a worksheet and perform calculations t
them, the only problem is that sometimes these values are "N/A" whic
is a string. Since we can't perform calculations on strings, m
program will crash

I was hoping to do something like this:

If value is integer the
perform calculatio
end i

how would i do this
--------
Message sent via www.excelforums.com

Checking if value is a number
 

Hi
see your other posting

--
Regards
Frank Kabel
Frankfurt, Germany

"jonx - ExcelForums.com"
schrieb im Newsbeitrag ...
How would I check to see if a value is an integer? Is there such a
function?

I am trying to grab values off a worksheet and perform calculations
to
them, the only problem is that sometimes these values are "N/A" which
is a string. Since we can't perform calculations on strings, my
program will crash.

I was hoping to do something like this:

If value is integer then
perform calculation
end if

how would i do this?
---------
Message sent via www.excelforums.com

Checking if value is a number
 

if isnumeric(value) then
perform calculation
End if

--
Regards,
Tom Ogilvy

"jonx - ExcelForums.com" wrote in
message ...
How would I check to see if a value is an integer? Is there such a
function?

I am trying to grab values off a worksheet and perform calculations to
them, the only problem is that sometimes these values are "N/A" which
is a string. Since we can't perform calculations on strings, my
program will crash.

I was hoping to do something like this:

If value is integer then
perform calculation
end if

how would i do this?
---------
Message sent via www.excelforums.com