Help with Forumula for Whole Numbers

Hello -

I have a column full of numbers. I need to a formula for the adjacent column that will allow me to identify only those that are whole numbers. How would I specify a criteria of whole number in an if function? For example, if I have 5.447, 6, 10, 8.76, and 4.53 in the first column, I would want to see only 6 and 10 identified as 'whole' in the new column, with all the others identified as 'decimal' or something. I know how to structure if functions, but I'm unclear as how to build the whole number criteria. Any help is much appreciated!

Hi,

With your first number in cell A1 :
=IF(INT(A1)=A1,"OK","Not Ok")
will do the job ...

HTH
Carim

Thank's so much for the help!