Is there a function that checks if a cell is an integar (no fraction)

Posted by Trevor on January 24, 2002 1:16 PM

Is there an inbuilt function tha checks if a number is a whole integar (non fraction) apologies for tortology :)
such as isodd checks if it is an odd number.
I have tried to find it but I have learnt that often it is staring u in the face.

tia

Posted by Juan Pablo G. on January 24, 2002 1:19 PM

Try with =INT(A1) = A1

Posted by Steve Hartman on January 24, 2002 1:22 PM

Inbuilt? No. But =int(A1)-A1=0 will return TRUE if A1 is an integer.

Posted by Trevor on January 24, 2002 7:06 PM

Re: Try with =INT(A1) = A1 thx very cute!