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

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

Allen.

"ileanardz" wrote:

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?
.