Function to check for whole numbers

[Das]

Hi All:

Does any one know of a funtion that would check wheather a cell value is a whole number or not, then return true or false?
eg If the value of A1 was 12.55 then A2 (providing that the formula is in A2) would = False; but if A1 was 3 then A2 would be True.

Thanks

 

[Ron Rosenfeld]

Hi All:

Does any one know of a funtion that would check wheather a cell value is a whole number or not, then return true or false?
eg If the value of A1 was 12.55 then A2 (providing that the formula is in A2) would = False; but if A1 was 3 then A2 would be True.

Thanks

=A1=INT(A1)


--ron

 

[DAS]

Thank You Ron. You were a BIG help.

Blessings

----- Ron Rosenfeld wrote: -----

Hi All:
eg If the value of A1 was 12.55 then A2 (providing that the formula is in A2) would = False; but if A1 was 3 then A2 would be True.

=A1=INT(A1)


--ron