Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
checking the absolute value of a number | Excel Discussion (Misc queries) | |||
Checking a date/number between two others | Excel Discussion (Misc queries) | |||
number checking | Excel Discussion (Misc queries) | |||
number checking | Excel Discussion (Misc queries) | |||
Checking a number of sheets | Excel Worksheet Functions |