ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Checking if integer (https://www.excelbanter.com/excel-programming/311384-checking-if-integer.html)

Jonx[_9_]

Checking if integer
 

Hello, I am trying to perform calculations on some values, but i woul
only like to perform the calculations if the value is a number. Fo
example, I am grabbing values off another sheet, and sometimes thes
values are 1, 2, 10, etc. but sometime, these values are N/A.

What i would like to do, is say:

if value is an integer, then

perform the calcuations

end if

how would i do this

--
Jon
-----------------------------------------------------------------------
Jonx's Profile: http://www.excelforum.com/member.php...fo&userid=1317
View this thread: http://www.excelforum.com/showthread.php?threadid=26330



All times are GMT +1. The time now is 07:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com