Identify Whole Number

[ileanardz]

How can excel identify a number when it is whole or it has decimals.

I am doing an IF function.

E.I.
If(A1=WHOLE NUMBER, YES, NO)

Is there some way?

 

[Luke M]

=IF(A1=INT(A1),TRUE,FALSE)

 

[Bob I]

=IF(INT(A1)=A1,"YES","NO")

 

[T. Valko]

=A1=INT(A1)

--
Biff
Microsoft Excel MVP

=IF(A1=INT(A1),TRUE,FALSE)

 

[ileanardz]

How can excel identify a number when it is whole or it has decimals.

I am doing an IF function.

E.I.
If(A1=WHOLE NUMBER, YES, NO)

Is there some way?

Thank you all.

While you were answer me, I searched and found what I need here:

http://groups.google.com/group/micr...d85b?lnk=gst&q=whole+numbers#4e4b97b209ccd85b

Thanks a lot!

 

[Allen]

how about
=if(rounddown(a1,0)=a1,"Yes","No").

Rounddown will round a number down to the specified number of digits.

Allen.