![]() |
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