Function that returns boolean value depending on whether a number is an integer

The title sums up basically what I'm looking for. Does anyone know of a function which will return a boolean value depending on whether a number is integer or not? Thanks

JRT

Originally Posted by Jrt

The title sums up basically what I'm looking for. Does anyone know of a function which will return a boolean value depending on whether a number is integer or not? Thanks

JRT

=IF(A1-INT(A1)=0)

If you find this isn't producing values in every instance (particularly when the value you're checking is the result of calculations):

=IF(ABS(A1-INT(A1))<10E-8)

Basically, this formula just checks to see if it's within a really small amount of an integer, which is quite often necessary when you're testing a calculated value.

Scott