Function to check for whole numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...


=A1=INT(A1)


--ron
 
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.
Click to expand...


=A1=INT(A1)


--ron
 
Back
Top